The following data relates to the item of raw material:Unit cost of raw materialR30Usage per week50 unitsFixed ordering costR25 per orderVariable holding cost per annum, as a % of unit cost10%Number of weeks in a year48Required:Drag and drop the correct answer by filling in the missing information:Order quantity150200300480Number of orders blank blank blank blankAverage inventory blank blank blank blankANNUAL INVENTORY COSTSRRRROrdering costs blank blank blank blankHolding costs blank blank blank blankTOTAL blank blank blank blank EOQ level 400 280 225 150 75 110 650 100 600 305 845 200 10 8 5 38 450 32 290 140 300 16 240 625 220 125 12 720Previous activityAssessment 5Jump to...Next activityAssessment 7Contact us Follow us You are logged in as LINDA NXUMALO (Log out)Data retention summaryGet the mobile appGet the mobile app
Question
The following data relates to the item of raw material:Unit cost of raw materialR30Usage per week50 unitsFixed ordering costR25 per orderVariable holding cost per annum, as a % of unit cost10%Number of weeks in a year48Required:Drag and drop the correct answer by filling in the missing information:Order quantity150200300480Number of orders blank blank blank blankAverage inventory blank blank blank blankANNUAL INVENTORY COSTSRRRROrdering costs blank blank blank blankHolding costs blank blank blank blankTOTAL blank blank blank blank EOQ level 400 280 225 150 75 110 650 100 600 305 845 200 10 8 5 38 450 32 290 140 300 16 240 625 220 125 12 720Previous activityAssessment 5Jump to...Next activityAssessment 7Contact us Follow us You are logged in as LINDA NXUMALO (Log out)Data retention summaryGet the mobile appGet the mobile app
Solution
The question is asking for the calculation of the number of orders, average inventory, annual inventory costs (ordering costs and holding costs), and the total for different order quantities. It also asks for the Economic Order Quantity (EOQ) level.
Here's how to calculate each:
-
Number of Orders: This is calculated by dividing the annual usage (Usage per week * Number of weeks in a year) by the order quantity.
-
Average Inventory: This is calculated by dividing the order quantity by 2.
-
Ordering Costs: This is calculated by multiplying the number of orders by the fixed ordering cost.
-
Holding Costs: This is calculated by multiplying the average inventory by the unit cost of raw material and then by the variable holding cost per annum.
-
Total: This is calculated by adding the ordering costs and the holding costs.
-
EOQ Level: This is calculated using the formula: sqrt((2 * annual usage * fixed ordering cost) / (unit cost of raw material * variable holding cost per annum)).
Please note that the above calculations are based on the assumption that the demand is constant and known with certainty, and that the lead time is zero or known with certainty.
The question seems to be asking for the calculations to be done for different order quantities (150, 200, 300, 480). However, without the actual numbers, I can't provide the specific answers.
I hope this helps! If you have any other questions, feel free to ask.
Similar Questions
You are given the following information for the year ended 31 October 2019: Cost item Amount (Sh) Purchase of raw materials 112,000 Returns inwards 8,000 Decrease in stock of raw materials 8,000 Direct wages 42,000 Carriage outwards 4,000 Carriage inwards 3,000 Production overheads 27,000 Increase in work-in-progress 10,000 The value of factory cost of goods completed is Select one: a. Sh 202,000 b. Sh 174,000 c. Sh 183,000 d. Sh 182,000
Consider the information provided in the following three (3) independent cases A, B and C. Calculate the missing values and choose the correct answer from the options provided. CASE ACASE BCASE C RRRRaw materials inventory, beginningBlank 152 50032 400Purchases209 000105 000Blank 2Raw materials, ending65 40084 00054 000Direct material used326 000Blank 3216 000Direct labour432 000262 500Blank 4Manufacturing overheadsBlank 5210 000220 000Current manufacturing costsBlank 6Blank 7702 000Work-in-process inventory, beginning108 600157 500Blank 8Work-in-process inventory, ending214 600168 000378 000Cost of goods manufactured980 000Blank 91 135 000Finished goods inventory, beginning223 000189 000Blank 10Finished goods inventory, ending545 900109 000108 000Cost of goods soldBlank 11Blank 121 058 400
What is the total inventory-related cost per year? (Note: you need to compute the totalannual ordering costs and annual carrying costs)
The following information relates to a business at its year end Item Amount (Sh) Item Amount (Sh) Sales 600,000 Opening stocks: Purchases of raw materials 100,000 Raw materials 20,000 Returns inwards 10,000 Work in progress 4,000 Returns outwards 15,000 Finished goods 68,000 Carriage inwards 8,000 Closing stocks: Carriage outwards 12,000 Raw materials 22,000 Direct labour 80,000 Work in progress 8,000 Factory overheads 150,000 Finished goods 60,000 Determine the following: (Write your answers with commas, e.g. 10,000 not 10000) 1. Cost of manufacturing during the year = Sh 2. Cost of goods manufactured = Sh 3. Cost of goods sold = Sh 4. Gross profit = Sh
Direct Materials Inventory WIP Inventory Finished Goods Inventory Factory Department Overhead Cost of Goods Sold Additional information is as follows: Cost of direct materials purchased during 20X5 Cost of direct materials requisitioned in 20X5 Cost of goods completed during 20X5 Factory overhead applied (120% of direct labor) LB Company has the following balances as of the year ended December 31, 20X5. ₱15,000 Dr. 34,500 Dr. 49,500 4,000Dr. 74,500 Dr. Dr. ₱41,000 47,000 102,000 48,000 Required: Compute beginning direct materials inventory. Compute beginning WIP inventory. Compute beginning finished goods inventory. Compute actual factory overhead incurred.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.