Answered step by step
Verified Expert Solution
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
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
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