Please Help
Cheng, Jim - O X Share Comments Autosum Bad SL 47 Neutral Insert Delete Format Clear Sort & Find & Filter Select Cells Editing AutoSave H . mid term excel - fall 2019 - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do X Cut Calibri 11 AA === Dyna Wrap Text General TZ Normal [G Copy Paste BIU. 8 Format Painter - A Merge & Center - $ Good % Formatting" Table Clipboard Font Alignment Number Styles c30 - fax B C D E F G H I 1 Midterm Exam: Excel problem(25pts) 2 Please include all details on this sheet. Formulas must be used. 3 If the number is wrong and you do not include enough detailed calculations, no partial credit will be given. 4 No credit will be given for just answers. J K L M N O P A 5 6 Leatherback Inc. manufactures two types of handbags-Standard and Custom-and applies manufacturing overhead to all units using machine hours. Production information follows. 7 Standard Custom 8 Anticipated volume (units) 58,500 31,200 9 Direct-material cost per unit 46 69 51 60 10 Direct-labor cost per unit 11 12 The controller, who is studying the use of activity-based costing, has determined that the firm's overhead can be identified with three activities: manufacturing setups, machine processing, and purchase orders. Data on the number of setups, machine hours, and purchase orders, which are the activities' three 13 respective cost drivers, follow. 14 question sheet 2 Sheet3 Standard Custom -- + 125% = mid term excel - fall 2019 - Excel Cheng, Jim - O X Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments == 2 Autosum General TZ Bad SL 47 AutoSave H H File Home Insert X Cut 6 Copy Paste Format Painter Clipboard G38 x Calibri BIU - - 11 - AA - - A 25 Wrap Text Merge & Center - Normal Good Neutral Insert Delete Format $ Sort & Find & Filter Select % 9.000 Number Formatting" Clear Table Font Alignment Styles Cells Editing for A D E G H I J K L M N O P Q R S 14 15 Setups 16 Machine hours 17 Purchase orders C Standard 176 62,400 200 F Custom 136 87,750 150 18 19 22 20 The firm's total overhead is: $23,423,400 21 It is subdivided as follows: manufacturing setups $5,110,560 machine processing $14,054,040 purchase orders $4,258,800 24 Required: 25 1. Compute the per unit total manufacturing cost of Standard and Custom handbags by using the company's current overhead costing procedures with machine hours.(npts) 26 Standard Custom 27 Direct Material $46 $69 28 Direct Labor $51 $60 29 Total Direct Cost $97 $129 30 31 32 2. Compute the per unit total manufacturing cost of Standard and Custom handbags by using activity-based costing.(12pts) 33 34 3. Assume that the current selling price of a Standard handbag is $330.00 and the marketing manager is contemplating a $60 discount to stimulate volume. Is this discount advisable? Show calculations to support your answer.(2pts) 35 36 4.Which method should the company use and why? List at least 3 reasons why. (3pts) 37 38 in question sheet 2 Sheet3 @ u - - + 110% Cheng, Jim - O X Share Comments Autosum Bad SL 47 Neutral Insert Delete Format Clear Sort & Find & Filter Select Cells Editing AutoSave H . mid term excel - fall 2019 - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do X Cut Calibri 11 AA === Dyna Wrap Text General TZ Normal [G Copy Paste BIU. 8 Format Painter - A Merge & Center - $ Good % Formatting" Table Clipboard Font Alignment Number Styles c30 - fax B C D E F G H I 1 Midterm Exam: Excel problem(25pts) 2 Please include all details on this sheet. Formulas must be used. 3 If the number is wrong and you do not include enough detailed calculations, no partial credit will be given. 4 No credit will be given for just answers. J K L M N O P A 5 6 Leatherback Inc. manufactures two types of handbags-Standard and Custom-and applies manufacturing overhead to all units using machine hours. Production information follows. 7 Standard Custom 8 Anticipated volume (units) 58,500 31,200 9 Direct-material cost per unit 46 69 51 60 10 Direct-labor cost per unit 11 12 The controller, who is studying the use of activity-based costing, has determined that the firm's overhead can be identified with three activities: manufacturing setups, machine processing, and purchase orders. Data on the number of setups, machine hours, and purchase orders, which are the activities' three 13 respective cost drivers, follow. 14 question sheet 2 Sheet3 Standard Custom -- + 125% = mid term excel - fall 2019 - Excel Cheng, Jim - O X Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments == 2 Autosum General TZ Bad SL 47 AutoSave H H File Home Insert X Cut 6 Copy Paste Format Painter Clipboard G38 x Calibri BIU - - 11 - AA - - A 25 Wrap Text Merge & Center - Normal Good Neutral Insert Delete Format $ Sort & Find & Filter Select % 9.000 Number Formatting" Clear Table Font Alignment Styles Cells Editing for A D E G H I J K L M N O P Q R S 14 15 Setups 16 Machine hours 17 Purchase orders C Standard 176 62,400 200 F Custom 136 87,750 150 18 19 22 20 The firm's total overhead is: $23,423,400 21 It is subdivided as follows: manufacturing setups $5,110,560 machine processing $14,054,040 purchase orders $4,258,800 24 Required: 25 1. Compute the per unit total manufacturing cost of Standard and Custom handbags by using the company's current overhead costing procedures with machine hours.(npts) 26 Standard Custom 27 Direct Material $46 $69 28 Direct Labor $51 $60 29 Total Direct Cost $97 $129 30 31 32 2. Compute the per unit total manufacturing cost of Standard and Custom handbags by using activity-based costing.(12pts) 33 34 3. Assume that the current selling price of a Standard handbag is $330.00 and the marketing manager is contemplating a $60 discount to stimulate volume. Is this discount advisable? Show calculations to support your answer.(2pts) 35 36 4.Which method should the company use and why? List at least 3 reasons why. (3pts) 37 38 in question sheet 2 Sheet3 @ u - - + 110%
