Question
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
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/05/663b0b764cd7c_590663b0b7620ab5.jpg)
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 0.2 kg per plate @ $10 per kg Direct Labour Variable Manufacturing Overhead 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](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started