Please complete the attached spreadsheet. There are 2 tabs that need to be completed 9-43 and 11-26. The blue boxes on the spreadsheets are the only items that needs to be answered.

WHB ACC 650 Module 5 11302016 Name: 9-43 11-26 Identifying the correct Proper Proper format Well written amounts Calculations for numbers reponse 10.00 15.00 10.00 15.00 Score test test test test Total 25.00 25.00 - Format Legend Entry Points Checksums Feedback Score Corrected entry 50.00 Amt 10.00 9-43 Calc 15.00 Format Resp Total 25.00 - - FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and and the perishable food box (type P) have the following material and labor requirements. Direct materials per 100 boxes Paperboard Corrugating Direct Labor per 100 boxes Type C Type P 30 20 0.25 70 pounds 30 pounds 0.50 hours Cost Paperboard Corrugating $ $ 0.20 per LB. 0.10 per LB. Direct labor rate $ 12.00 per Hour The following manufacturing-overhead costs are anticipated for the next year. The predetermined overhead 495,000 units for each type of box. Manufacturing overhead is applied on the basis of direct-labor hours. Budgeted Labor Hours Indirect material Indirect labor Utilities Property taxes Insurance Depreciation Total 3,712.50 $ $ $ $ $ $ $ 10,500 50,000 25,000 18,000 16,000 29,000 148,500 The following selling and administrative expenses are anticipated for the next year. Salaries and Fringe Benefits - Sales Advertising Salaries and Fringe Benefits - Management Salaries and Fringe Benefits - Clerical Miscellaneous Administrative expenses Total $ $ $ $ $ $ 75,000 15,000 90,000 26,000 4,000 210,000 The sales forecast for the next year is as follows: Sales Volume Sales Price Type C 500,000 $ 90 The following inventory information is available for the next year. The unit production costs for each produc next year. Type C Expected Starting Inventory 10,000 Desired Ending Inventory 5,000 Paperboard 15,000 5,000 Expected Starting Inventory Desired Ending Inventory Income Tax Rate: 40% Required: Prepare a master budget for FreshPak Corporation for the next year. Include the followin 1. Sales budget. Type C Sales Boxes Sales Price/Box Sales Revenue $ - 2. Production budget. Type C Desired Ending Inventory Less: Expected Starting Inventory Change in inventory-Increase/(Decrease) Add: Sales Units Production - 3. Direct-material budget. Calculate raw materials used in Production Type C Production Pounds/unit Type C Type C Pounds Type P Production Pounds/unit Type P Type P Pounds Total Pounds Paperboard Calculate Raw Material Puchases Desired Ending Inventory Less: Expected Starting Inventory Change in inventory-Increase/(Decrease) Paperboard - - Production pounds Raw Materials purchased Price per Pound Purchases $ - 4. Direct-labor budget. Type C BoxesProduced Labor Hour/Unit Hours Rate Labor Cost $ - 5. Manufacturing-overhead budget. Budgeted Manufacturing Overhead Budgeted Labor Hours Overhead Application Rate per Labor hour Manufacturing Overhead Indirect material Indirect labor Utilities Property taxes Insurance Depreciation Total 6. Selling and administrative expense budget. Selling & Administrative Costs Salaries and Fringe Benefits - Sales Advertising Salaries and Fringe Benefits - Management Salaries and Fringe Benefits - Clerical Miscellaneous Administrative expenses Total 7. Budgeted income statement. Compute the manufactur-ing cost per unit for each type of box Direct Material/Unit-Paperboard Direct Material/Unit-Corrugating Direct Labor Type C Applied Overhead Total Per Unit Type C Sales Revenue Less: Cost of Goods Sold Gross Margin Less: Selling & Administrative Costs Income before taxes Less: Taxes Net Income $ - anned food, fruit, and vegetables. The canned food box (type C) nts. edetermined overhead rate is based on a production volume of direct-labor hours. Type P 500,000 $ 130 per 100 boxes costs for each product are expected to be the same this year and Type P 20,000 15,000 Corrugating 5,000 10,000 Include the following schedules. Type P $ - Type P - Corrugating Corrugating - $ - Type P $ - #DIV/0! Type P $ - $ - Type P $ Total - $ - $ - $ - 11-26 Amt 10.00 Calc 15.00 Format Resp Total 25.00 - - The following data are the actual results for Marvelous Marshmallow Company for October. Actual Output Actual Variable Overhead Actual Fixed Overhead Actual Machine Time $ $ 9,000 cases 405,000 122,000 40,500 hours Standard cost and budget information for Marvelous Marshmallow Company follows: Standard Variable Overhead Rate Standard Machine Hours Budgeted Fixed Overhead Budgeted Output $ $ 9.00 4 120,000 10,000 per machine hour per case per month case/month Required: Use any of the methods explained in the chapter to compute the following variances. Indicate wh favorable or unfavorable, where appropriate. a. Variable-overhead spending variance. Actual Machine Time (hours) Standard Variable Overhead Rate Standard Variable Overhead Rate Actual Machine Time (hours) Actual Variable Overhead Rate Actual Variable Overhead Variable-overhead spending variance $ - $ - b. Variable-overhead efficiency variance. Budget Machine Hours (based onn Actual output) Standard Variable Overhead Rate Flex Budget Variable Overhead Actual Machine Hours Standard Variable Overhead Rate Standard Variable Overhead Variable-overhead efficiency variance c. Fixed-overhead budget variance. Budgeted Fixed Overhead Actual Fixed Overhead Fixed-overhead budget variance $ - $ - d. Fixed-overhead volume variance. Budgeted Fixed Overhead Actual Output Budgeted Overhead Application Rate Applied Fixed Overhead Fixed-overhead volume variance Build a spreadsheet: Construct an Excel spreadsheet to solve the preceding requirement. Show if the following information changes: actual output was 9,100 cases, and actual variable overhea Actual Output Actual Variable Overhead Actual Fixed Overhead Actual Machine Time $ $ 9,100 cases 395,000 122,000 40,500 hours Standard cost and budget information for Marvelous Marshmallow Company follows: Standard Variable Overhead Rate Standard Machine Hours Budgeted Fixed Overhead Budgeted Output $ $ a. Variable-overhead spending variance. 9.00 4 120,000 10,000 per machine hour per case per month case/month b. Variable-overhead efficiency variance. c. Fixed-overhead budget variance. d. Fixed-overhead volume variance. any for October. ny follows: machine hour wing variances. Indicate whether each variance is Favorable Favorable Favorable Positive ceding requirement. Show how the solution will change nd actual variable overhead was $395,000. ny follows: machine hour