Question
REQUIRED a) Calculate the closing value of stock using the weighted average method (10) b) Calculate the economic order quantity (3) c) Calculate the number
REQUIRED
a) Calculate the closing value of stock using the weighted average method (10)
b) Calculate the economic order quantity (3)
c) Calculate the number of orders (2)
When completing the template below ensure that numbers are written without the R symbol and without spacing for example R2 500 is filled in as 2500 .Where necessary round of the numbers to 2(two) decimal places. e.g R15,789 is filled in as 15.79
(a)
Date
Purchased
Sold
Balance
Units
Price/u
Amount
Units
Price/u
Amount
Units
Price/u
Amount
Opening
Answer
Answer
Answer
7
Answer
Answer
Answer
Answer
Answer
Answer
Answer
Answer
Answer
9
Answer
Answer
Answer
Answer
Answer
Answer
12
Answer
Answer
Answer
Answer
Answer
Answer
Answer
Answer
Answer
18
Answer
Answer
Answer
Answer
Answer
Answer
Snappy Chef (Pty) Ltd is a manufacturer of kitchenware in South Africa, due to the energy crisis in the country one of their fast-moving products has been the stainless-steel whistling kettle used on gas stoves. The company uses the weighted average method to value their stock, management has requested that you assist them with valuing their inventory at the end of August 2023. Furthermore, management is reviewing the inventory management system to ensure they don't run short of one of their key raw material components, steel. Additional information There were 50 bags in stock at the end of July 2023, valued at R5 000 Steel is purchased in 80-kilogram bags and 7800 bags are used each year. The cost of placing a typical order for steel is estimated at R300, and the annual cost of carrying steel in inventory is R40 per bag per year. The company uses the perpetual inventory method
REQUIRED
a) Calculate the closing value of stock using the weighted average method (10)
b) Calculate the economic order quantity (3)
c) Calculate the number of orders (2)
When completing the template below ensure that numbers are written without the R symbol and without spacing for example R2 500 is filled in as 2500 .Where necessary round of the numbers to 2(two) decimal places. e.g R15,789 is filled in as 15.79
(a)
Date
Purchased
Sold
Balance
Units
Price/u
Amount
Units
Price/u
Amount
Units
Price/u
Amount
Opening
Answer
Answer
Answer
7
Answer
Answer
Answer
Answer
Answer
Answer
Answer
Answer
Answer
9
Answer
Answer
Answer
Answer
Answer
Answer
12
Answer
Answer
Answer
Answer
Answer
Answer
Answer
Answer
Answer
18
Answer
Answer
Answer
Answer
Answer
Answer
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
Accounting A Comprehensive Guide For Beginners
Authors: Robert McCarthy
1st Edition
1638180474, 978-1638180470
