Question: 1. Use the information in the data tab to create the following reports. For each report you will include all cost (direct materials, direct labor,

1. Use the information in the data tab to create the following reports. For each report you will include all cost (direct materials, direct labor, and manufacturing overhead) and the costs will be broken down by behavior (fixed costs and variable costs). a. Manufacturing budget (static) for 2020, assuming the 4,000 budgeted kayaks will be produced. b. Flexible manufacturing budget for the first quarter ended March 31, 2020. Assume activity levels of 900,1,000, and 1,050. (Remember the static budget is for 1 year, but the flexible budget is only for 3 months) c. Manufacturing responsibility report for the quarter ended March 31, 2020, when 1,050 kayaks were made. 4 B 0 Current Designs Rotomolded Line Kayaks budgeted for production in 20214,000 Quarters in 2020 Manufacturing overhead budget for 2020 Variable costs Indireot materials: Manufacturing supplies Mainteriance and utilities Total variable costs $40,00053,80088,000$181,800 Fised oosts 12 Supervision Budgeted unit costs 19 Polyethylene powder-per pound 20 Finishingkits - each a1 Typellabor-per hour 22 Type llabor-per hour \begin{tabular}{rr} $ & 15 \\ $ & 170 \\ $ & 15 \\ $ & 12 \\ \hline \end{tabular} Budgeted labor usage 25 Typellabor-hours 26 Typell labor-hours (27) 28 Polyethylene powder required perkayak-pound 54 29 Finishingkits required perkayak- kit 30 31 Kayaks produced in the first quarter 1,050 32 35. Costs incurred in first quarter
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
