Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 5 (16 marks) Stacey Morrows decided to start a business that manufactures a medical device, which required the purchase of assets at a total

image text in transcribedimage text in transcribed
Question 5 (16 marks) Stacey Morrows decided to start a business that manufactures a medical device, which required the purchase of assets at a total cost of $800,000. Stacey started the business, Safe Health Inc. (Safe) on July 1, 2021 with a cash investment of $200,000 and a new loan of $600,000. The terms of the loan stipulated that interest of 8% (annually) would be due at the end of each month and a payment of $50,000 principal would be due at the end of each quarter, with the first payment due on September 30, 2021. Safe's budgeted revenue and expenses are as follows: Selling price per unit 700 Variable manufacturing costs per unit: Direct materials 172 Direct labour 80 Variable overhead 90 Fixed manufacturing costs per month: Salaries of production supervisors and engineers 3150,000 Lease of manufacturing plant $125.000 Depreciation of equipment $ 35,000 Sales commission per unit (10%% of selling price) S 70 Other variable administrative and general expenses per unit sold 3 30 Fixed selling, administrative, and general expenses per month: Salaries of marketing and administrative staff $223,000 Depreciation of office equipment $ 16,000 Additional information: " Actual sales were 2,300 units in November and 2,400 units in December. Expected sales for the second half of the year are as follows: January 2,500 units February 2,700 units March 2,900 units April 3,100 units May 3,400 units June 3,700 unitsAll sales are on credit: the normal terms are 30 days from the sale date, but customers who pay early receive a 29% discount. Collection of accounts receivable is expected to display the following patterns: 40% will be collected in the month of sale (80% of these customers will take the discount) 50% will be collected in the first month after sale (none of these customers will be eligible for the discount) 5% will be collected in the second month after sale (none of these customers will be eligible for the discount) 59% will be uncollectable All direct materials purchases are incurred uniformly with 100% of payment made in the month of purchase. In order to meet fluctuations in customer demand, a finished goods inventory equal to 200 units plus 10% of demand expected for the following month must be maintained. On January 1, 2022 there were 450 units in finished goods inventory. All expenses are paid as incurred. A minimum cash balance of $10,000 must be maintained at the beginning of each quarter, and the cash balance on January 1, 2022 was $18,000. Required: 3) Prepare Safe's cash budget for the third quarter ending March 31, 2022. (Do NOT prepare monthly cash budgets.) (15 marks) b) Indicate whether there will be sufficient cash for Safe to make the loan payment due on March 31, 2022. If there will NOT be sufficient cash, recommend to Stacey how much additional financing is required. (1 mark)

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_2

Step: 3

blur-text-image_3

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

Financial Shenanigans

Authors: Howard Schilit

2nd Edition

0071386262, 9780071386265

More Books

Students also viewed these Accounting questions

Question

Find and sketch the equipotential lines of F(z) = (1 + i)/z.

Answered: 1 week ago

Question

What is the persons job (e.g., professor, student, clinician)?

Answered: 1 week ago

Question

how would you fix this common issue?

Answered: 1 week ago