Question
Can someone confirm the Cash Budget for me Additional information: -Cash balance on January 1 next year is estimated to be $900,000. -Direct materials are
Can someone confirm the Cash Budget for me
Additional information:
-Cash balance on January 1 next year is estimated to be $900,000.
-Direct materials are paid for in the year they are ordered.
-Total factory overhead (variable and fixed combined) is estimated to be $896,500 and includes $100,000 of depreciation. Use this information when preparing the cash budget.
-Factory overhead costs are paid in the year incurred.
-All sales are for cash.
-Marketing and administrative expenses are estimated at 10% of sales revenue for the period and are paid when incurred.
-Income taxes for the current year are estimated at $400,000 and will be paid next year.
My Solution:
Parameters DM Inv DM Inv Product 1 Product 2 DM Cost January 1 December 31 Estimated Units Sold Estimated Sales Price Estimated FG Invy January 1 Desired FG Invy December 31 Direct material A per unit (per lb.) Direct material B per unit (per lb.) Direct material C per unit (each) Estimated Direct Labor Hours/Unit Estimated Direct Labor Rate/Hour 80,000 160 30,000 35,000 50,000 200 10,000 12,000 4 2 0 2 $15 836,000 $530,000 3 5,000 40,000 35,000 8,000 20 Other estimated information: Cash Bal January 1 Total overhead Depreciation Mktg & Admin Exp. (% of sales) Income taxes 900,000 $796,500 $100,000 $2,280,000 (10% of Sales Revenue) $400,000 (Not Paid Until Next YearStep 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