Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you help me fill in the white cells on the blue picture? Inputs (Assumptions) for the Profit Planning Year Jan. 1 to Dec. 31,

image text in transcribedimage text in transcribedimage text in transcribedCan you help me fill in the white cells on the blue picture?

Inputs (Assumptions) for the Profit Planning Year Jan. 1 to Dec. 31, 2017 MyArmor, Inc Set Input Values Back to Original Amounts As of Dec. 31 2016 Applies to All Qtrs. Quarter in the 2017 Planning Year 1st Quarter Fix the Format of All Yellow Cells in 2017 1st 2nd 3rd 4th of 2018 Sales Budget Sales in Units Average Selling Price per Unit Cash Colleerion Pattern for Sales in the: 1st Quarter 14,000 units 530 per unn 60% 12,000 units 528 per uni 10% 4096 18,000 units S34 per unit 18,000 units S34 per unit 2nd 70% Remainder 3rd Quarter 4th Quarter Production Bud 3,000 units Finished Units in Inventory as of 1231/16 (the prior Forecasted Sales in Units st Quarter of 2018 (n ycar) 16,000 units % of the Next Qtr.'s Sales in Units to Have in This Qtr.'s Ending Inventory Raw Materials Budget 10 oz Ounces of PlasticSteel Powder (PsP) Required per Finished Unit ired" Have in This Qrs Ending Invetory % nr Next Qtr. 's "Ounces of Ps P R 20% 30% 30% 20% Ounces of PsP in Raw Materials Inven as of 123116 (the priory 15,000 oz 130,000 z Forecasted "Ounces of PsP Required" in the 1st Qtr of 2018 (next year) Cost of PsP per Ounce Cash Payment Pattern for PsP Purchased in the 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $1.20 per oz 1.10 per oz 30% 50% S1.10 per o2 $1.20 per oz 30% 80% Remainder Direct Labor Bud Direct Labor Hours (hrs) per Finished Unit Avcrage Cost of a Direct Labor Hour 0.20 hrs S18 per hour 318 per bor S20 per hour $20 per hour Manufacturing Overhead Budget vanable Overhead Cost Rate per Direct Labor Hour (DLH) . Total Fixed Manufacturing Overhcad Cost per Quarter 8 per DLH S50,000 59,000 r Quarter Included in Fixed Manu

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

Guide To Audit Data Analytics

Authors: AICPA

1st Edition

1945498641, 978-1945498640

More Books

Students also viewed these Accounting questions