Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please I need 1-Sales Budget 2-Purchase Budget 3-S&A Budget 4-cash Budget. thank you Based on the information below prepare a: (1) Sales Budget (2) Purchase

please I need 1-Sales Budget 2-Purchase Budget 3-S&A Budget 4-cash Budget. thank you image text in transcribed
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 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 Z 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 75% 25% 20% Beginning Inventory units & cost Product Z Cost 2,200 $25 Purchases Paid in the month of purchase Pald in the subsequent month 8096 20% Selling and administrative expenses (includes $25,000 depreciation) Variable Expense $175,000 $ 10 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

Principles Of Financial Accounting Chapters 1 To 18

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel

12th Edition

9781118978740

More Books

Students also viewed these Accounting questions