Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

pleas I need sales budget, purchase budget et cash budget for this homework Based on the information below prepare a (1) Sales Budget (2) Purchase

pleas I need sales budget, purchase budget et cash budget for this homework
image text in transcribed
Based on the information below prepare a (1) Sales Budget (2) Purchase Budget (3) S & A Budget (4) Cash Budget for Jan thru March (30 pts) Remember prepare thru Excel. Set up your template based on the information below and link as much information as possible. ABC Company Balance Sheet, December 31 Inform I Cash Accounts receivable Finished goods Land Plant and equipment Less: accumulated depreciation Total assets $41,700 192,000 55,000 100,000 $750,000 25,000 725,000 $1,113,700 $55,000 Accounts payable to suppliers Common Stock Retained Earnings Total liabilities and equity $200,000 858,700 1,058,700 $1,113,700 Estimated sales of product 2 January February March April May Selling price Collections from customers Collected in month of sale Collected the following month Desired finished goods inventory (of next month's unit sales) 10,000 10,700 11,200 11,000 10,500 $70 7596 25% 20% Beginning Inventory units & cost Product 2 Cost 2,200 $25 Purchases Paid in the month of purchase Paid in the subsequent month 80% 20% Selling and administrative expenses includes $25,000 depreciation) Variable Expense $175,000 $19 Fixed per unit sold

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

Management Accounting For Business Decisions

Authors: Colin Drury

2nd Edition

1861527705, 978-1861527707

More Books

Students also viewed these Accounting questions

Question

What is biomass and how is it used?

Answered: 1 week ago

Question

Explain the seven dimensions of an organizations climate.

Answered: 1 week ago

Question

Describe the five types of change.

Answered: 1 week ago