Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel formula! can somone please show me the formula to get the answers for the rest of the Direct materilas Budget ? please show work

Excel formula! can somone please show me the formula to get the answers for the rest of the Direct materilas Budget ? please show work thank you!
image text in transcribed
image text in transcribed
Angie Company, a manulacturer, predicts salas of 3,600 units in January, 3,300 units in February, 4,800 units in March, and 5,300 units in Apri. The compary wants each monthis ending fnished goods inventory to equal 20% of next monthis predicted unt sales. Beginning finiahed goods inventory for January is. 720 units. Each unt of finished goods requires 0.30 pounds of direct materisks at a cost of S8.00 per pound, and 2.0 hours of direct labor at a cost of $16 per hour. Additionaly, the company wants each monthis ending raw materiah inventory to equal 40% of next months budgeted production. Propare a sales budget, a production budget, a direct materials and a drect libor budgat. A Anota Aamanmon

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

Organizational Network Analysis Auditing Intangible Resources

Authors: Anna Ujwary-Gil

1st Edition

1032085215, 978-1032085210

More Books

Students also viewed these Accounting questions