Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribed
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 6% (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 $150,000 Lease of manufacturing plant $125,000 Depreciation of equipment $ 35,000 Sales commission per unit (10% of selling price) $ 70 Other variable administrative and general expenses per unit sold | $ 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:\fAll sales are on credit: the normal terms are 30 days from the sale date, but customers who pay early receive a 2% discount. Collection of accounts receivable is expected to display the following patterns: 0 40% will be collected in the month of sale (60% of these customers will take the discount) 0 50% will be collected in the rst month after sale (none of these customers will be eligible for the discount) 0 5% will be collected in the second month after sale (none of these customers will be eligible for the discount) 0 5% will be uncollectable All direct materials purchases are incurred uniformly with 100% of payment made in the month of purchase. In order to meet uctuations in customer demand, a nished 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 nished 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: a) Prepare Safe's cash budget for the third quarter ending March 31, 2022. (Do NOT prepare monthly cash budgets.) (1 5 marks) b) Indicate whether there will be sufficient cash for Safe to make the loan payment clue on March 31, 2022. If there will NOT be sufcient 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

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

Hospitals What They Are And How They Work

Authors: Don Griffin, Donald J Griffin

3rd Edition

076372758X, 9780763727581

More Books

Students also viewed these Accounting questions

Question

1. To generate a discussion on the concept of roles

Answered: 1 week ago