Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Budgeted sales Expected April (units) 2,500 May (units) 6,000 June (units) 3,000 July (units) 2,500 August (units) 2,000 Selling Price/unit $120.00 Cash collection pattern Month
Budgeted sales | Expected |
April (units) | 2,500 |
May (units) | 6,000 |
June (units) | 3,000 |
July (units) | 2,500 |
August (units) | 2,000 |
Selling Price/unit | $120.00 |
Cash collection pattern | |
Month of sale | 40% |
Following month | 55% |
Uncollectible | 5% |
Cash payments for materials | |
Month of purchase | 40% |
Following month | 60% |
Production requirements | |
Raw material per unit (lb) | 5 |
Raw mat. cost per lb | $7.00 |
Direct labor hours per unit | 0.5 |
Direct labor rate per hour | $40.00 |
Variable MOHD per DL hour | $10 |
Fixed MOHD per month | $57,950 |
Depreciation in Fixed MOHD | $20,000 |
Selling & administrative costs | |
Variable S&A cost per unit sold | $1.25 |
Fixed S&A cost per month | $63,000 |
Depreciation in Fixed S&A cost | $10,000 |
Other cash outflows | |
Cash dividends paid each month | $15,000 |
Equipment purchases May | $47,820 |
Equipment purchases June | $154,600 |
Desired ending inventory | |
Finished Goods | 20% |
Raw Materials | 40% |
Cash ($) | $30,000 |
Beginning account balances - March 31 | |
Cash ($) | $37,745 |
Accounts Receivable ($) | $132,000 |
Finished Goods inventory | $30,750 |
FG inventory (units) | 410 |
Raw Materials inventory | $32,200 |
Raw Materials (lb) | 4,600 |
Accounts Payable ($) | $55,000 |
Land | $520,000 |
Buildings and equipment | $1,800,000 |
Accumulated Depreciation | ($750,000) |
Common stock | $500,000 |
Retained earnings | $1,247,695 |
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