Part A Maharaj Garage & Car Supplies sells a variety of automobile cleaning gadgets including a variety of hand vacuums. The business began the first quarter (January to March) of 2024 with 20 (Mash up Dirt) deep clean, cordless vacuums at a total cost of $126,800. During the quarter, the business completed the following transactions relating to the "Mash up Dirt" brand. January 8 January 31 February 4 February 10 February 28 March 4 March 10 March 31 March 31 105 vacuums were purchased at a cost of $6,022 each. In addition, the business paid a freight charge of $518 cash on each vacuum to have the inventory shipped from the point of purchase to their warehouse. The sales for January were 85 vacuums which yielded total sales revenue of $768,400. (25 of these units were sold on account to Mandys Cleaning Supplies, a longstanding customer) A new batch of 65 vacuums was purchased at a total cost of $449,800 8 of the vacuums purchased on February 4 were returned to the supplier, as they were either not of the model ordered or were not powering up. During the month 58 vacuums were sold at a price of $9,780 each. A customer, to whom 9 vacuums were sold during the first business day of February, returned 3 of the units, as they were of the Homecare brand. Owing to an increased demand, a further 120 vacuums were purchased at a cost of $8,000 each; the supplier gave a 2.5% trade discount on each vacuum. 130 vacuums were sold during March at a unit selling price of $10,500. An actual quarterly count of inventory was carried out which revealed that there were 26 units of the Mash up Dirt brand of the merchandise in the storeroom. Unless otherwise stated, assume that all purchases were on account and received on the dates stated. Required: i) Prepare a perpetual inventory record for Maharaj Garage & Car Supplies, Mash up Dirt vacuums using the first in, first out (FIFO) method of inventory valuation to determine the value of ending inventory on March 31, 2024, and the total amount to be assigned to cost of goods sold for the period. (20 marks) ii) Given that selling, distribution and administrative costs associated with the Mash up Dirt brand of vacuums for the quarter were $52,760, $82,340 and $183,740 respectively, prepare an income statement for Maharaj Garage & Car Supplies (Mash up Dirt) for the quarter ended March 31, 2024. (5 marks) iii) Journalize the January transactions, assuming the business uses a: Part B Periodic inventory system. Perpetual inventory system (7 marks) Endeavour Enterprise sells a product that cost $200 per unit and has a monthly demand of 500 units. The annual holding cost per unit is calculated as 2% of the unit purchase price. It costs the business $30 to place a single order. The maximum number of units sold in one week is 150 and the minimum number of units sold is 80. The supplier takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. 1) What is the cost minimizing solution for this product each year? Verify your answer. (5 marks) ii) Determine the re-order level, minimum inventory level and maximum inventory level for the product.

Part A Maharaj Garage & Car Supplies sells a variety of automobile cleaning gadgets including a variety of hand vacuums. The business began the first quarter (January to March) of 2024 with 20 (Mash up Dirt) deep clean, cordless vacuums at a total cost of $126,800. During the quarter, the business completed the following transactions relating to the "Mash up Dirt" brand. January 8 January 31 February 4 February 10 February 28 March 4 March 10 March 31 March 31 105 vacuums were purchased at a cost of $6,022 each. In addition, the business paid a freight charge of $518 cash on each vacuum to have the inventory shipped from the point of purchase to their warehouse. The sales for January were 85 vacuums which yielded total sales revenue of $768,400. (25 of these units were sold on account to Mandys Cleaning Supplies, a longstanding customer) A new batch of 65 vacuums was purchased at a total cost of $449,800 8 of the vacuums purchased on February 4 were returned to the supplier, as they were either not of the model ordered or were not powering up. During the month 58 vacuums were sold at a price of $9,780 each. A customer, to whom 9 vacuums were sold during the first business day of February, returned 3 of the units, as they were of the Homecare brand. Owing to an increased demand, a further 120 vacuums were purchased at a cost of $8,000 each; the supplier gave a 2.5% trade discount on each vacuum. 130 vacuums were sold during March at a unit selling price of $10,500. An actual quarterly count of inventory was carried out which revealed that there were 26 units of the Mash up Dirt brand of the merchandise in the storeroom. Unless otherwise stated, assume that all purchases were on account and received on the dates stated. Required: i) Prepare a perpetual inventory record for Maharaj Garage & Car Supplies, Mash up Dirt vacuums using the first in, first out (FIFO) method of inventory valuation to determine the value of ending inventory on March 31, 2024, and the total amount to be assigned to cost of goods sold for the period. (20 marks) ii) Given that selling, distribution and administrative costs associated with the Mash up Dirt brand of vacuums for the quarter were $52,760, $82,340 and $183,740 respectively, prepare an income statement for Maharaj Garage & Car Supplies (Mash up Dirt) for the quarter ended March 31, 2024. (5 marks) iii) Journalize the January transactions, assuming the business uses a: Part B Periodic inventory system. Perpetual inventory system (7 marks) Endeavour Enterprise sells a product that cost $200 per unit and has a monthly demand of 500 units. The annual holding cost per unit is calculated as 2% of the unit purchase price. It costs the business $30 to place a single order. The maximum number of units sold in one week is 150 and the minimum number of units sold is 80. The supplier takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. 1) What is the cost minimizing solution for this product each year? Verify your answer. (5 marks) ii) Determine the re-order level, minimum inventory level and maximum inventory level for the product.

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter8: Current And Contingent Liabilities

Section: Chapter Questions

Problem 29CE: Unearned Sales Revenue Brand Landscaping offers a promotion where a customers lawn will be mowed 20...

See similar textbooks

Related questions

Question

Transcribed Image Text:Part A Maharaj Garage & Car Supplies sells a variety of automobile cleaning gadgets including a variety of hand vacuums. The business began the first quarter (January to March) of 2024 with 20 (Mash up Dirt) deep clean, cordless vacuums at a total cost of $126,800. During the quarter, the business completed the following transactions relating to the "Mash up Dirt" brand. January 8 January 31 February 4 February 10 February 28 March 4 March 10 March 31 March 31 105 vacuums were purchased at a cost of $6,022 each. In addition, the business paid a freight charge of $518 cash on each vacuum to have the inventory shipped from the point of purchase to their warehouse. The sales for January were 85 vacuums which yielded total sales revenue of $768,400. (25 of these units were sold on account to Mandys Cleaning Supplies, a longstanding customer) A new batch of 65 vacuums was purchased at a total cost of $449,800 8 of the vacuums purchased on February 4 were returned to the supplier, as they were either not of the model ordered or were not powering up. During the month 58 vacuums were sold at a price of $9,780 each. A customer, to whom 9 vacuums were sold during the first business day of February, returned 3 of the units, as they were of the Homecare brand. Owing to an increased demand, a further 120 vacuums were purchased at a cost of $8,000 each; the supplier gave a 2.5% trade discount on each vacuum. 130 vacuums were sold during March at a unit selling price of $10,500. An actual quarterly count of inventory was carried out which revealed that there were 26 units of the Mash up Dirt brand of the merchandise in the storeroom. Unless otherwise stated, assume that all purchases were on account and received on the dates stated. Required: i) Prepare a perpetual inventory record for Maharaj Garage & Car Supplies, Mash up Dirt vacuums using the first in, first out (FIFO) method of inventory valuation to determine the value of ending inventory on March 31, 2024, and the total amount to be assigned to cost of goods sold for the period. (20 marks) ii) Given that selling, distribution and administrative costs associated with the Mash up Dirt brand of vacuums for the quarter were $52,760, $82,340 and $183,740 respectively, prepare an income statement for Maharaj Garage & Car Supplies (Mash up Dirt) for the quarter ended March 31, 2024. (5 marks) iii) Journalize the January transactions, assuming the business uses a: Part B Periodic inventory system. Perpetual inventory system (7 marks) Endeavour Enterprise sells a product that cost $200 per unit and has a monthly demand of 500 units. The annual holding cost per unit is calculated as 2% of the unit purchase price. It costs the business $30 to place a single order. The maximum number of units sold in one week is 150 and the minimum number of units sold is 80. The supplier takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. 1) What is the cost minimizing solution for this product each year? Verify your answer. (5 marks) ii) Determine the re-order level, minimum inventory level and maximum inventory level for the product.

Expert Solution

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here