Master Budget and Responsibility Accounting Kaizen approach to activity-based budgeting The Jerico store of Jiffy Mart,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Master Budget and Responsibility Accounting Kaizen approach to activity-based budgeting The Jerico store of Jiffy Mart, a chain of small neighborhood convenience stores, is preparing its activity-based budget for January 2018. Jiffy Mart has three product categories: soft drinks (35% of cost of goods sold [COGS), fresh produce (25% of COGS), and packaged food (40% of COGS). Jiffy Mart has a Kaizen (continuous improvement) approach to budgeting monthly activity costs for each month of 2018. Each successive month, the budgeted cost-driver rate decreases by 0.4% relative to the preceding month. So, for example, February's budgeted cost-driver rate is 0.996 times January's budgeted cost-driver rate, and March' s budgeted cost-driver rate is 0.996 times the budgeted February rate. Jiffy Mart assumes that the budgeted amount of cost-driver usage remains the same each month. The following table shows the four activities that consume indirect resources at the Jerico store, the cost drivers and their rates, and the cost-driver amount budgeted to be consumed by each activity in January 2018. Activity Ordering Delivery Shelf stocking Customer support Cost Driver Number of purchase ouders Number of deliveries Hows of stocking time Number of items sold C. d. January 2018 Budgeted January 2018 Amount of Cost Driver Used Budgeted Fresh Packaged Soft Cost-Driver Rate Drinks Snacks Food $45 $41 $10.50 $0.09 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formalas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. Requirement What are the total budgeted cost for each activity and the total budgeted indirect cost for March 2018? 14 24 12 62 16 172 4,600 34,200 Saving & Submitting Solution 1 Save file to desktop. 8. Create folder on desktop, and label COMPLETED EXCEL PROJECTS b. Save your solution in the folder you just created; add-solution-date to end of file name 2 Upload and submit your file to be graded. 8. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open Click Upload button under step 3 Click Submit button under step 4 INSTRUCTIONS ENTERANSWERS 14 19 94 10,750 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link; this will bring up your Score Card 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback D7 1 2 N10 A 2 :X ✓ fx B 3 Activity 4 Ordering 5 Delivery 5 Shelf-stocking 7 Customer support 3 Total 9 =0.09*10750 Soft Drinks C (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong.) $630 492 168 414 Fresh Packaged Snacks Food $1,080 2,542 1,806 3,078 $1,704 $8,506 E $630 779 987 968 $3,364 Total F $2,340 3,813 2,961 4,460 $13,574 0 Master Budget and Responsibility Accounting Kaizen approach to activity-based budgeting The Jerico store of Jiffy Mart, a chain of small neighborhood convenience stores, is preparing its activity-based budget for January 2018. Jiffy Mart has three product categories: soft drinks (35% of cost of goods sold [COGS), fresh produce (25% of COGS), and packaged food (40% of COGS). Jiffy Mart has a Kaizen (continuous improvement) approach to budgeting monthly activity costs for each month of 2018. Each successive month, the budgeted cost-driver rate decreases by 0.4% relative to the preceding month. So, for example, February's budgeted cost-driver rate is 0.996 times January's budgeted cost-driver rate, and March' s budgeted cost-driver rate is 0.996 times the budgeted February rate. Jiffy Mart assumes that the budgeted amount of cost-driver usage remains the same each month. The following table shows the four activities that consume indirect resources at the Jerico store, the cost drivers and their rates, and the cost-driver amount budgeted to be consumed by each activity in January 2018. Activity Ordering Delivery Shelf stocking Customer support Cost Driver Number of purchase ouders Number of deliveries Hows of stocking time Number of items sold C. d. January 2018 Budgeted January 2018 Amount of Cost Driver Used Budgeted Fresh Packaged Soft Cost-Driver Rate Drinks Snacks Food $45 $41 $10.50 $0.09 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formalas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. Requirement What are the total budgeted cost for each activity and the total budgeted indirect cost for March 2018? 14 24 12 62 16 172 4,600 34,200 Saving & Submitting Solution 1 Save file to desktop. 8. Create folder on desktop, and label COMPLETED EXCEL PROJECTS b. Save your solution in the folder you just created; add-solution-date to end of file name 2 Upload and submit your file to be graded. 8. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open Click Upload button under step 3 Click Submit button under step 4 INSTRUCTIONS ENTERANSWERS 14 19 94 10,750 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link; this will bring up your Score Card 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback D7 1 2 N10 A 2 :X ✓ fx B 3 Activity 4 Ordering 5 Delivery 5 Shelf-stocking 7 Customer support 3 Total 9 =0.09*10750 Soft Drinks C (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong.) $630 492 168 414 Fresh Packaged Snacks Food $1,080 2,542 1,806 3,078 $1,704 $8,506 E $630 779 987 968 $3,364 Total F $2,340 3,813 2,961 4,460 $13,574 0
Expert Answer:
Answer rating: 100% (QA)
SOLUTION 1 2 3 4 5 6 7 8 9 10 11 12 13 14 B Activity Ordering Delivery S... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides estimates concerning the companys costs: Fixed Cost per...
-
Tucker Company produced 5,400 units of product that required 3.7 standard hours per unit. The standard variable overhead cost per unit is $6.80 per hour. The actual variable factory overhead was...
-
The following data is given for the Bahia Company: Budgeted production Actual production Materials: Standard price per pound Standard pounds per completed unit Actual pounds purchased and used in...
-
North American Badgers (Taxidea taxus) occur throughout the western United States and Great Plains of North America, with the geographic range extending east to central Ohio (Messick, 1987; Whitaker...
-
The number of bad checks that a bank receives during a 5-hour business day is a Poisson random variable with = 2. What is the probability that it will not receive a bad check on any one day during...
-
Give a geometrical interpretation of the linear transformations on R3 defined by each of the six 3 3 permutation matrices (1.30).
-
What are some of the nonverbal clues to deception?
-
One Product Corp. (OPC) incorporated at the beginning of last year. The balances on its post-closing trial balance prepared on December 31, at the end of its first year of operations, were: The...
-
To solve this model economy, we reformulate the competitive equilibrium into the social planner's problem. First of all, in social planner's problem, all markets must clear, and thus N = Nd = N, and...
-
Robert takes loan of $14k to buy a truck and seller is offering a uniform series of payment at 6.5% interest for 5 years. Calculate the monthly payment that Robert has to pay to buy that truck
-
Negligence in Healthcare Choose a contemporary example of medical negligence in healthcare. You can begin by visiting the Internet Resources provided by your textbook , journals, case studies, as...
-
Ruth and Greg are married and earned a joint income of $62,000 in 2020. They paid a total of $5,500 in 2020 for benefits, such as their health insurance coverage. They paid $3,298 in state and local...
-
Explain why adequate audit planning is essential before commencement of actual audit work. (b) Outline the deficiencies of the audit in the above case and elaborate with reasons.
-
Differentiate between the linear magnification and the focal length of an objective. 2. Why is the low-power objective placed in position when the microscope is stored or carried?
-
Vera Bradley Inc. reports the following results for the month of June: Sales Revenue (20,000 units) $1,200,000 Variable costs 800,000 Fixed costs 300,000 Net income $ 100,000 Management of...
-
In what capacity do non-human hosts facilitate the evolutionary trajectory and dissemination of influenza viruses? Furthermore, delineate the dual mechanisms through which influenza evolves, and...
-
1. On network, Search one kind of HCI technology that you think will be the next hot technology. Briefly describe the application scenarios of this technology, and attach relevant news links or video...
-
After looking at the resources, explain what a spirit image is. Why might looking at a god and/or a human in terms of their spirit be helpful if you want to eliminate some of the divisions between...
-
Consider the feedback system shown in Figure 10.27. Using Routh's stability criterion, determine the range of the control gain \(K\) for which the closed-loop system is stable. FIGURE 10.27 Problem...
-
Draw a block diagram for the feedback control of a single-link robot arm system, which consists of a DC motor to produce the driving force and an encoder to measure the joint angle. Clearly label...
-
The transfer function of a dynamic system is given by \[G(s)=\frac{20 s+50}{s^{3}+10 s^{2}-5 s-30}\] a. Using Routh's stability criterion, determine the stability of the open-loop system. b. Suppose...
Study smarter with the SolutionInn App