The table below provides the aggregate plan of T-shirts produced by Zara. It is known that the firm uses a chase plan. The firm's labor cost is $10/unit, hiring cost is $350 per unit of increase, and unit firing cost is $400 per unit of decrease in production. Given this information, what is the number in the cell with the question mark? (If needed, round your final answer to nearest whole number. (c)orsdemir. Copyrighted material.) Month# Forecast# Net requirement# Prod. rate# Labor cost# Hiring cost Firing cost 1,000 1,696 2,000 300 Jan Feb Mar Apr May 1,800 2,000 300 100 1,500 1,696 2,000 300 100 1,500 100 1,500 - 16,960 20,000 3,000 1,000 ? 243,600 106,400 0 0 490,000 0 0 680,000 80,000 0

The table below provides the aggregate plan of T-shirts produced by Zara. It is known that the firm uses a chase plan. The firm's labor cost is $10/unit, hiring cost is $350 per unit of increase, and unit firing cost is $400 per unit of decrease in production. Given this information, what is the number in the cell with the question mark? (If needed, round your final answer to nearest whole number. (c)orsdemir. Copyrighted material.) Month# Forecast# Net requirement# Prod. rate# Labor cost# Hiring cost Firing cost 1,000 1,696 2,000 300 Jan Feb Mar Apr May 1,800 2,000 300 100 1,500 1,696 2,000 300 100 1,500 100 1,500 - 16,960 20,000 3,000 1,000 ? 243,600 106,400 0 0 490,000 0 0 680,000 80,000 0

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

Well water inc. wants to produce and sell a new flavored water in order topenetrate the market, the product will have to sell at 2.60 per 12 oz bottle thefollowing data has been collected: Annual sales 50,000 bottlesProjected selling and administrative costs 8,000Desired profit 80,000The target cost per bottle is _____ per bottle (2 decimal places)
Please do not give solution in image format thanku XYZ Mobile makes phones in multiple production lines. The daily production run is for 820 phones. Each phone has a standard time of 5.1 minutes. Each production line operates for 9 hours per day. Do not include commas in your answer and enter percentages as decilmal points. For example enter 1,402 as 1402 and 67.5% as 0.675. How many production lines are needed to meet the daily demand? What is the utilization of the production lines? What is the maximum daily output of the system?
Your Corporation manufactures four products that use the same raw material and production machine. Your Company is experiencing a shortage of pounds of the raw material. Information related to the four products are shown below. Products A B C D Selling price $40 $32 $35 $65 Variable cots $34 $22 $27 50 Machine hours per unit 6 8 5 7 Pounds per unit 18 20 28 38 To maximize profit next month, in what order would it be best to schedule production (first to last)? a. A, B, C, D b. A, D, B, C c. B, D, A, C d. D, A, C, B
Which of the following is a performance measure used to measure customer service for a build to stock customer strategy? Select all that apply! - Group of answer choices - Line item fill rate - Return Rate - Inventory Values - Return on Sales
A short-term model of measurement that can be used to evaluate an organization's operational objectives: O Exclusive objective O KPI SMART O Primary objective
Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Inc. Kate Co. Number of orders 6 30 Units per order 1,000 420 Sales returns: Number of returns 4 5 Total units returned 50 140 Number of sales calls 13 5 Colleen sells its products at $290 per unit. The firm’s gross margin ratio is 20%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Cost Driver and Rate Sales calls $ 800 per visit Order processing 180 per order Deliveries 410 per order Sales returns 270 per return and $3 per unit returned Sales salary 107,000 per month Required: 1. Using customers as the cost objects, classify the activity costs…
Please answer correct calculation please asap please Don't answer by pen paper plz.
Please do not give solution in image formate thanku. Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,000; winter, 8,000; spring, 7,000; summer, 12,000. Inventory at the beginning of fall is 500 units. At the beginning of fall, you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on overtime during winter or spring if overtime is necessary to prevent stock outs at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $100 for each temp; layoff, $200 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; straight time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season.
U-RIDE, Inc. currently produces the electric engines that are used in golf carts made and sold by the Company. Electco has offered to sell the electric engines to U-RIDE at a price of $277 each. Current production information follows: Unit-level material and labor 2$ 230 Facility-level depreciation of manufacturing equip. Product-level engine production supervisor's salary Annual facility-level utilities $ 6,100/month $ 3,100/month $20,500 Buying the engines will free up manufacturing capacity that could be used to make a new economy line golf cart that would produce an additional $11,600 profit per year. U-RIDE is currently operating profitably producing and selling 3,100 engines annually. Based on this information, which of the following is true? Multiple Choice The $111,600 is not relevant because it is an estimate. Buying the units would increase U-RIDE's cost by $35 per unit. of 10
Which of the following pertains to an efficient supply chain? a. It deals with innovative products b. The product life cycle will be short c. It is worthwhile to invest in good forecasting systems d. All of the above
QUESTION 3 Samoto Limited (SL) relies on an external supplier for production capacity. In order to gain access to a certain level of production capacity, SL will have to commit to an annual contract before the start of the operating period. The contract will stipulate the production capacity entitlement of SL. SL has a choice of three contracts: Contract Mega, Contract Upper, and Contract Soso. Regardless of the choice of contract, the company will be subject to three states of nature: high demand, medium demand and low demand. The net profits generated by each of the contracts under the three states of nature are as follows: Net profit (£000) Medium demand High demand Low demand Contract Mega Contract Upper Contract Soso 20,000 17,000 16,500 15,500 16,000 15,000 11,000 12,000 13,000 The probabilities of the states of nature are as follows: High demand Medium demand Low demand 25% 45% 30% Probability
Help me