batineh_Cost16e_e6_30_start - Excel razeim batineh File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Calibri 12 ab Wrap Text General * Cut e Copy *Format Painter & Share AutoSum , AY O Fill - Sort & Find & Clear Filter - Select- Editing Paste BIU. -A Merge & Center $ - % 4.0 .00 .00 0 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells D13 X for Number of items sold E F H 1 J K L M N o P Q R 6 7 AB 1 Master Budget and Responsibility Accounting 2 Activity-based budgeting 3 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). The following table shows the four activities that consume indirect resources at the Jerico store, the cost drivers and their rates, and 4 the cost-driver amount budgeted to be consumed by each activity in January 2018. 5 January 2018 Budgeted January 2018 Amount of Cost Driver Used Budgeted Soft Fresh Packaged 9 Activity Cost Driver Cost-Driver Rate Drinks Snacks Food 10 Ordering Number of purchase orders $45 14 24 14 Delivery Number of deliveries $41 12 62 19 12 Shelf stocking Hours of stocking time $10.50 16 172 94 13 Customer support Number of items sold $0.09 4,600 34,200 10,750 14 15 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste 16 from the Instructions tab you will be marked wrong. 17 INSTRUCTIONS ENTERANSWERS + 8 11 @ + 100% Type here to search j X 3:22 PM 10/21/2020 D batineh_Cost16e_e6_30_start - Excel razeim batineh File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share AutoSum Calibri 12 ab Wrap Text Currency * Cut e Copy *Format Painter LO Fill - Paste BIU. -A- EE Merge & Center $ % 4.0 .00 .00 0 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Clear Sort & Find & Filter - Select Editing Clipboard Font Alignment Number Cells E6 X fc =B6+C6+D6 H 1 J K L M N o P Q R 5 A B D E F G 1. What is the total budgeted indirect cost at the Jerico store in January 2018? What is the total budgeted cost of each activity at the Jerico store for January 2018? What is the 1 budgeted indirect cost of each product category for January 2018? (Always use cell references and formulas where appropriate to receive full credit. If you 2 copy/paste from the Instructions tab you will be marked wrong.) 3 4 Soft Fresh Packaged Drinks Snacks Food Total 6 Ordering $14 $24 $14 $52 7 Delivery 12 62 19 93 8 Shelf-stocking 16 172 94 282 9 Customer support 4,600 34,200 10,750 49,550 10 Total cost 11 Percentage of total indirect costs 12 13 2. Which product category has the largest fraction of total budgeted indirect costs? 14 15 Fresh Snacks consumes the largest fraction of total budgeted indirect costs. 16 17 18 19 INSTRUCTIONS ENTERANSWERS + @ + 100% Type here to search j o X 3:22 PM 10/21/2020 D
