Question 17 Month- -Expected Demand- Production Days Jan- 1000- -21 Feb- 700 18 Mar 800 -18 Apr- 1250- -22 May- -1350- 19 Jun- 1300 -20 Cost Information: Subcontracting cost SR 22 per unit per month Average pay rate SR 12 per hour Labor-hours to produce a unit - 4 hours per unit Daily working hours -8 hours a) Using excel, calculate the total cost of the following plan: Plan: is to maintain a constant workforce at a level necessary to meet the lowest demand month and to meet all demand above this level by subcontracting. (Answer in Field) Attach your solutions. Add your answer

Question 17 Month- -Expected Demand- Production Days Jan- 1000- -21 Feb- 700 18 Mar 800 -18 Apr- 1250- -22 May- -1350- 19 Jun- 1300 -20 Cost Information: Subcontracting cost SR 22 per unit per month Average pay rate SR 12 per hour Labor-hours to produce a unit - 4 hours per unit Daily working hours -8 hours a) Using excel, calculate the total cost of the following plan: Plan: is to maintain a constant workforce at a level necessary to meet the lowest demand month and to meet all demand above this level by subcontracting. (Answer in Field) Attach your solutions. Add your answer

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

Question 1: The MTM manufacturing company disclose the following information of their inventories, for Mar, 2020. The data related to the beginning Raw material inventory and purchases of raw material inventory are as follow: Date Particulars Units Rate(Rs) Mar 01 Inventory (beginning ) 3685 17 08 Purchases 4600 19 14 Purchases 3100 22 22 Purchases 2300 19 27 Purchases 3000 21 During the month of January raw material were used for production was worth Rs. 243645. FOH was ¾ of Direct Material, and Direct labor cost Rs. 1,80,000. There is no Beginning inventory of Work in Process and Finished good, while Ending inventory worth Rs. 30000 of finished goods and 25% is still work in process. Required: A. Cost of Goods Statement for each case. LIFO Method Weighted Average Method
__________________________________________________________________________Question No. 1A) Prepare the total budgeted sales in dollars for the quarter ended March 31, 2021 usingthe following data.Feb Mar AprQuantity of budgeted units for salesJan 25000 Feb 55000 Mar 35000 Apr 40000 Expected selling prices of each unitJan $12 Feb $15 Mar $20 Apr $22 B) What is Budget & how does it helps management in managing business?
QUESTION 3Space and equipment are major components of cost in warehouse management. Cube utilization refers to the efficient use of space in the warehouse both on the floor and in height. You are reviewing the efficiency in relation to space utilization in the warehouse.(a) The following information is identified for some of the stock items in the warehouse. Stock keeping unit(SKU) | Number of PalletsSKU 010 2 SKU 020 5 SKU 030 13 SKU 040 7 SKU 050 4 a) The pallets are being stored 3 high. Calculate the percentage utilisation in the warehouse? (b) It is found that the low rate of space utilisation is because the warehouse is using a fixed location method of storage. Recommend two other methods of stock location the organisation can use giving reasons why?
(information may be needed from main question) Holding cost = 19% * 42(unit cost) = $ 7.98 Reordering cost =$ 515 280 days per year annual demand = 16200 Q* = 418 Lead times recorded from the past 10 cycles 4.6 6.2 4.1 4.1 4.9 5.0 5.6 6.2 4.6 4.0 1. The most recent order for compressors has been placed on Sunday April 19, 2020 at 8:00 a.m. What is the probability that the order will not have arrived by the end of Sunday April 26, 2020?
question 6 In a Q system, the demand rate for strawberry ice cream is normally distributed, with an average of 295pints per week.The lead time is 8 weeks. The standard deviation of weekly demand is 10 pints. Refer to the standard normal table1 for z-values. a. The standard deviation of demand during the 8-weeklead time is ______pints. (Enter your response rounded to the nearest whole number.) b. The average demand during the 8-week lead time is_____ pints. (Enter your response as an integer.) c. The reorder point that results in a cycle-service level of 92percent is _______ pints. (Enter your response rounded to the nearest whole number.) 1: Data Table The table below shows the total area under the normal curve for a point that is Z standard deviations to the right of the mean. Z 0.00 0.01 0.02 0.03 0.04 0.05 0.06 0.07 0.08 0.09 0.0 0.5000 0.5040 0.5080 0.5120 0.5160 0.5199 0.5239 0.5279 0.5319 0.5359 0.1 0.5398…
QUESTION THREEWarehousing is an important contributor to both productivity management and quality in a manufacturing industry. (a) Discuss symptoms of inefficient material handling in a warehouse.The following information is provided; Stock keeping unit (SKU) Number of PalletsSKU 010 4 SKU 020 6 SKU 030 14 SKU 040 8 SKU 050 5 The pallets are being stored 3 high. Calculate: i. The number of pallet positions required to store the full consignment? ii. The percentage space utilisation in this warehouse.
Question 1 Determine whether the following statements are true or false. Statement T or F 1. JIT emphasizes continuous improvement, respect for people, and standard work practices 2. Different from JIT, Lean operations externally focused on the customer 3. Qualitative Methods are used when situation is vague and little data exist 4. Predict sales of existing products and services is called Demand forecasting 5. Forecasting is about predicting the future.
Q.No.01. Draw a flowchart showing steps involved in Risk Management Process.
QUESTION 3Warehousing is an important contributor to both productivity management and quality in a manufacturing industry. (a) Discuss symptoms of inefficient material handling in a warehouse.The following information is provided; Stock keeping unit(SKU) | Number of PalletsSKU 010 4 SKU 020 6 SKU 030 14 SKU 040 8 SKU 050 5 The pallets are being stored 3 high. Calculate: i. The number of pallet positions required to store the full consignment? ii. The percentage space utilisation in this warehouse.
Q: How the net profit is calculated for product explain and derive formula for it?
1. What is adjustment buckles of mask. 2. How much price of adjustment buckles of mask. 3. The problem of wear adjustment buckles of mask.
52. During a move to a new location, the inventory records of 98 Degrees were misplaced. The bookkeeper has been able to gather some data for the July purchases: Units - Unit cost - Total cost July 5 = 10,000 - 65 - 650,000 10 = 12,000 - 70 - 840,000 15 = 15,000 - 60 - 900,000 25 = 14,000 - 55 - 770,000 On July 31, 17,000 units were on hand. The sales for July amounted to P6,000,000 or 60,000 units at P100 per unit. The entity always used a perpetual FIFO inventory costing system. Gross profit on sales for July was P2,400,000. What was the cost of the inventory on July 31?