Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Lotric Co. produces suction plates for toddlers. The plan for the next period is as follows: Sale of 9,000 plates in January, February, and March,

image text in transcribed

Lotric Co. produces suction plates for toddlers. The plan for the next period is as follows: Sale of 9,000 plates in January, February, and March, and the same number of plates is expected for April of 2022. The selling price will be $19 per unit. The inventory of silicon (material for suction plates) on 1 January is 80 kg. The policy is that the ending material inventory amounts to 10% of next month's production requirements. The planned level of Finished Goods inventory on 1 January will be 2,500 units. The company wants to lower its finished goods ending inventory policy not to finance excessive working capital. But to not experience delays in deliveries of their products to customers, it still plans that the ending finished goods inventory each month should be 15% of next month's sales. Monthly selling & administrative expenses are estimated at $14,000 (including $6,000 of depreciation) plus 20% of sales for commissions. Budgeted manufacturing costs for January and February 2022 are as below: Direct Materials Direct Labour Variable Manufacturing Overhead 0.2 kg per plate @ $10 per kg 6 minutes per plate @ $20 per hour allocated @$8 per DLH Monthly budgeted fixed manufacturing overhead amounts to $55,000 plus $10,000 of depreciation. 25% of all sales are sold to local shops and are made on credit. They are paid the next month. The remaining sales on Amazon are paid in the month of sale. The company pays half of the purchased materials in the month of purchase and half in the following month. Labour and relevant overhead costs are paid in the month the liability is incurred. Selling and administration expenses are paid each month. At the beginning of February 2022, the company will take a loan in the amount of 30,000 as its cash balance has been diminished because of recent equipment upgrades. The interest rate for the loan will be 6% per annum paid monthly. The principal will be repaid at the end of year 2022. The opening cash balance on 1 February (before the loan drawdown) is planned to be $2,500. REQUIRED (show all your workings): 1. Prepare the following budgets for January and February 2021. (9 marks) i. Production Budget (in units) ii. Material Purchases Budget (in quantities and dollars) 2. Cash Budget for FEBRUARY ONLY. (7 marks)

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

Sound Investing, Chapter 23 - Internal Control

Authors: Kate Mooney

1st Edition

0071719458, 9780071719452

More Books

Students also viewed these Accounting questions

Question

Define belongingness, competence, and autonomy.

Answered: 1 week ago

Question

What are some sources of ethical guidance?

Answered: 1 week ago