Abdullah records the following monthly purchases and sales of an item. Month Number bought Cost of each unit (€) Number sold November 110 22 73 December 60 26 71 January February 70 30 49 50 28 53 March 80 24 37 April 40 32 71 Assuming he has no opening stock (Before November), 1. What is the remaining stock at the end of the period (April)? 2. What is the cost (cost of purchase) of the total inventory (Currency in Saudi Riyals))? 3. If each unit is sold for 35SR, What is the income for Abdullah's company till end of April?

Abdullah records the following monthly purchases and sales of an item. Month Number bought Cost of each unit (€) Number sold November 110 22 73 December 60 26 71 January February 70 30 49 50 28 53 March 80 24 37 April 40 32 71 Assuming he has no opening stock (Before November), 1. What is the remaining stock at the end of the period (April)? 2. What is the cost (cost of purchase) of the total inventory (Currency in Saudi Riyals))? 3. If each unit is sold for 35SR, What is the income for Abdullah's company till end of April?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Assuming nil opening stocks prepare store ledger cards and calculate the value of the closing stock from the data provided below using each of the following methods: FIFO LIFO W.Avg Receipts Date Units Rate October 1 100 12.50 October 8 85 15.00 October 16 95 11.95 October 20 115 13.00 Issues October 55 October 65 October October 25 October 115
36. The president of Value Filters became very enthusiastic about using EOQS to plan the sizes of her production runs, and instituted lot sizing based on EOQ values before she could properly estimate costs. For one particular filter line, which had an annual de- mand of 1,800 units per year and which was valued at $2.40 per unit, she assumed a holding cost based on a 30 percent annual interest rate and a setup cost of $100. Some time later, after the cost accounting department had time to perform an analysis, it found that the appropriate value of the interest rate was closer to 20 percent and the setup cost was about $40. What was the additional average annual cost of holding and setup incurred from the use of the wrong costs?
Distinguish between FOB destination and FOB origin. Whatprocedures should the auditor follow concerning acquisitions of inventory on an FOBorigin basis near year-end?
5. __________________refers to the benefits of holding some inventory rather than completely depending on the futures market for supply a. Contract yield b. Convenience yield c. Storage benefit d. Holding benefit
Describe,, How do inventory control policies impact a company's cash flow and profitability?
In determining open-to-buy, what is subtracted from planned purchases? O On hand On order EOM stock BOM stock Question 37 Your department is planning a 10 percent increase in sales for the entire three- month period (February-April). Sales for the period last year were $19,000. Fifty percent of the total planned sales are projected to occur in March, and 25 percent of sales are planned to occur in each of the other two months. Planned stock-sales ratio for each month is 2.0. Total planned reductions for the period are 5 percent of planned sales. Reductions are projected to occur for each month as follows: February (10 percent), March (40 percent), and April (50 percent). An ending inventory of $5,000 is planned for the period. PLANNED PURCHASES FOR FEBRUARY ARE: O $24,200 O $15.779 O None (overbought). $10.895.50
04/30/2 Problem #1 - Jasper Inc., a company that sells air conditioning units for cars intends to reduce its total annual inventory cost. The annual demand is expected to be 6,000 units if market conditions are unfavorable, and 9,000 units if market conditions are favorable. The Purchasing & Warehousing Manager estimates that the ordering cost is $20.00 per order and the holding cost is $2.00 per unit per year. a. - Calculate the Economic Order Quantity (EOQ), Annual Ordering Cost, Annual Holding Cost and Total Annuarinventory Cost under unfavorable and favorable market conditions. b. - The Purchasing & Warehousing Manager identified two improvement projects in conjunction with her team: Project A: Reduction of ordering cost to $18.00. Project B: Reduction of holding cost to $1.40 per unit per year. Which project would result in greater reduction of the EOQ and Total Annual Inventory Cost? Which of the projects would you recommend and why? Show all your calculations.
Add two (2) new customers, two (2) old customers and two (2) new POS transactions. SalesID InvoiceNo TransDate Item Description Color Size qty Price StoreID YearID Brand Name Address CurrID YEARVAL 82605 10828 06-Dec-09 8720400000227 REGULAR CIGARS 1 21.74 TCS 2009 HENRI WINTERMANS Yetty BDS 2009 47075 45036325 26-Aug-08 POSTCARDS POSTCARDS 1 1.4 CS 2008 Guenna BDS 2008 4590 60007295 14-Jan-08 3707-11-6 BLOUSES BLK/MLT L 1 586 CC 2008 GOTTEX Yankee CORAL REEF HOTEL USD 2008 4599 60007301 15/1/2008 3007-319-18 PANTS CORAL XS 1 200 CC 2008 CUT LOOSE Quigly YEARWOOD RD BLK ROCK USD 2008
comment if the stock is undervalued or overvalued if CAMP return is 12% & historical estimated return is 10% Options are : Overrated undervalued correctly priced cannot be determined
b. Given the following information: Expected demund during lead time 300 units Standard devintion of lead time demand 30units Determine the following, assuming that lead time is constant and lead time demand is normally distributed: The ROP that will provide a stockout risk of 1% during lead time The safety stock needed to attain a 1% risk of stockout during lead time Would n stockout risk of 2% require more or less safety stock than a 1% risk? Explain. i. ii. iii. Based on III, would the ROP be larger, smaller or unaffected if the acceptable risk were 2% instead of 1%? Explain iv.
Define the following terms:i. Capitalii. Partneriii. Entrepreneuriv. Demandv. Supply
What are the different type of wedges for stock charting