Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is all the information given. just the budget reports are neccesary. No comparison with the actual. 1. Use the information in the data tab
This is all the information given. just the budget reports are neccesary. No comparison with the actual. 1. Use the information in the data tab to create the following reports. For each report you will include ali 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. Current Designs Rotomolded Line Kasaks budgeted for production in 2021 4,000 Quarters in 2020 Manulacturing overhead budget for 2020 Variable costs Indirect materials Manuraoturing supplies Maintenance and utilities Total variable costs Fined costs Supervision Insurance Depreciation Total fired costs Total Budgeted unit costs Polgethylene powder - per pound Finishingkits - each Typellabor-per hour Tipelllabor - per hour Budgeted labor usage Typellabor-hours Type ll fabor-hours Folgethylene powder required per kayak - pound Finishiog kits required perkayak - kit Kayaks produced in the first quarter 1,050 Costs incurred in first quarter Polyethiglene powder Firishing kits Typellabor Tipe lllabor Indirect materials Manufacturing supplies Mairitenance and utilities Bupervision Insurance Depreoiation Total 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started