Answered step by step
Verified Expert Solution
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
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
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