Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
This is all the information given. just the budget reports are neccesary. No comparison with the actual.
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Practitioners Blueprint To Construction Auditing

Authors: Ron Risner

1st Edition

0894137263, 978-0894137266

More Books

Students also viewed these Accounting questions

Question

What is multiplex and encoder

Answered: 1 week ago

Question

denigration of emotional outbursts; being reserved;

Answered: 1 week ago