Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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:

image text in transcribed

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 Year

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

Internal Auditing Assurance And Advisory Services

Authors: Kurt R. Reding, Paul J. Sobel, Urton L. Anderson, Michael J. Head, Sridhar Ramamoorti, Mark Salamasick, Cris Riddle

5th Edition

1634541367, 978-1634541367

More Books

Students also viewed these Accounting questions

Question

=+16.10. 2.19 16.9 | Assume u(1) Answered: 1 week ago

Answered: 1 week ago

Question

Describe the linkages between HRM and strategy formulation. page 80

Answered: 1 week ago