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...
-
For each transaction, (1) Analyze the transaction using the accounting equation, (2) Record the transaction in journal entry form, (3) Post the entry using T-accounts to represent ledger accounts....
-
If you know how wage rates are determined, you should know how interest rates are determined. The same tools apply. Discuss.
-
What is the concept of bounded rationality? How might the concept be used to help distinguish between the provision of serviceable and unserviceable accounting information in environmental accounting?
-
Presented below is the comparative balance sheet for Diatessaron Inc., a private company reporting under ASPE, at December 31, 2017 and 2016: Additional information: 1. Cash dividends of $15,000 were...
-
You are considering going in with a classmate, Tom A. Toe, to buy the land because you plan to construct a retail outlet on it, either immediately or in the future. For simplicity, assume that you...
-
The following unadjusted trial balance is for Power Demolition Company as of the end of its April 30, 2013, fiscal year. The April 30, 2012, credit balance of the owners capital account was $46,900,...
-
on 2 a) Find S tan(3t)lnt dt et red d out of b) Find the area of the region bounded by: y = e2", y = e and a = In4 e question
-
Given an independent central bank, monetary policy actions are more likely than fiscal policy actions to be: A. implementable quickly. B. effective when a specific group is targeted. C. effective...
-
What is the structure of the finance department within health services organizations?
-
What is the primary purpose of the income statement?
-
How do high-performance salespeople in hotel, motel, and convention center services build relationships?
-
List and describe the three main types of consumer buying situations.
-
Describe how to integrate the visual tool you found it into a stakeholder analysis. Also, show how to create a template of stakeholder analysis for a project including an example of the visual tool...
-
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...
-
Have you experienced artistic portrayals of your own culture or identity that you find offensive? If so, do you think they should be censored? The statue of President Theodore Roosevelt flanked by an...
-
What is the core approach to an anthropology of art?
-
Describe some of the reasons that people make art and give examples of symbolism and ritual in art.
Study smarter with the SolutionInn App