Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the information below prepare a (1) Sales Budget (2) Purchase Budget (3) S & A Budget (4) Cash Budget for lan thru March

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 lan 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 7546 25% 20% Beginning Inventory units & cost Product 2 Cost 2,200 $25 Purchas Paid in the month of purchase Paid in the subsequent month 80% 20% Selling and administrative expenses includes 525.000 depreciation) Variable Expense 5175,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

Commercial Energy Auditing Reference Handbook

Authors: Steve Doty

3rd Edition

1498769268, 978-1498769266

More Books

Students also viewed these Accounting questions