Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. based on the information below prepare a: (1) sale

Based on the information below prepare a: (1) Sales Budget (2) Purchase Budget (3) Cash...

70.2K

Verified Solution

Question

Accounting

Based on the information below prepare a: (1) Sales Budget (2) Purchase Budget (3) Cash Budget for Jan thru April, 2022 (30 pts) Remember prepare thru Excel. Set up your template based on the information below and link as much information as possible. (30 pts)

ABC Company Balance Sheet, December 31, 2021

Cash $41,700

Accounts receivable 192,000

Inventory 55,000

Land 100,000

Plant and equipment $750,000

Less: accumulated depreciation 25,000 725,000

Total assets $1,113,700

Accounts payable to suppliers $55,000

Common Stock $200,000

Retained Earnings 858,700 1,058,700

Total liabilities and equity $1,113,700

Estimated sales of product Z

January 10,000

February 10,700

March 11,200

April 11,000

May 10,500

Sale price per unit $75

Cost of inventory per unit $40

Collections from customers Collected in month of sale 72%

Collected the following month 28%

Desired ending inventory (% of next month's unit sales) 20%

Desired Units Purchased (% of current months sales) 40%

Paid in the month of purchase 75%

Paid in the subsequent month 25%

Selling and administrative expenses (includes $25,000 depreciation) $175,000 fixed Variable Expense $ 15 per unit sold

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students