Ch. 19 Q9 Shoney Video Concepts produces a line of video streaming servers that are linked to personal computers for storing movies. Thesedevices have very fast access and large storage capacity.Shoney is trying to determine a production plan for the next 12 months. The main criterion for this plan is that the employment level isto be held constant over the period. Shoney is continuing In Its R&D efforts to develop new applications and prefers not to cause anyadverse feelings with the local workforce. For the same reason, all employees should put in full workweeks, even if that is not thelowest-cost alternative. The forecast for the next 12 months isMONTHJanuaryFebruaryMarchAprilMayJuneFORECASTDEMAND600see900600400300MONTHJulyAugustForecastBeginning inventoryAvailable productionEnding inventoryCostsLost salesInventoryTotalSeptemberOctoberNovemberDecemberManufacturing cost is $200 per server, equally divided between materials and labor. Inventory storage cost is $5 per unit per monthand is assigned based on the ending Inventory level A shortage of servers results in lost sales and is estimated to cost an overall $20per unit short.FORECASTDEMAND200The Inventory on hand at the beginning of the planning period is 200 units. Ten labor hours are required per DVD player. The workdayIs eight hours.Develop an aggregate production schedule for the year using a constant workforce. For simplicity, assume 22 working days eachmonth except July, when the plant closes down for three weeks' vacation (leaving seven working days). Assume that total annualproduction capacity is greater than or equal to total annual demand (1.e., compute workforce level based on annual demand andannual capacity). (Leave no cells blank - be certain to enter "0" wherever required. Indicate monthly shortages using a negativeending Inventory level. Round up the "number of workers" to the next whole number and round down your monthly "Availableproduction" values to the nearest whole number.)January200300700600800900February#ICC JU800March April900600HLA$May400June July August September October November December300 200180Q SearchCHI****f5%LC5200f6200< Previ4-09 of 14ly4***m&70TotalTotalNext >

An aggregate production plan is the operation management method that helps determine the…

Develop an aggregate production schedule for the year using a constant workforce. For simplicity, assume 22 working days each month except July, when the plant closes down for three weeks' vacation (leaving seven working days). Assume that total annual production capacity is greater than or equal to total annual demand (.e., compute workforce level based on annual demand and annual capacity). (Leave no cells blank - be certain to enter "0" wherever required. Indicate monthly shortages using a negative ending Inventory level. Round up the "number of workers" to the next whole number and round down your monthly "Available production" values to the nearest whole number.)

Develop an aggregate production schedule for the year using a constant workforce. For simplicity, assume 22 working days each month except July, when the plant closes down for three weeks' vacation (leaving seven working days). Assume that total annual production capacity is greater than or equal to total annual demand (.e., compute workforce level based on annual demand and annual capacity). (Leave no cells blank - be certain to enter "0" wherever required. Indicate monthly shortages using a negative ending Inventory level. Round up the "number of workers" to the next whole number and round down your monthly "Available production" values to the nearest whole number.)

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

Related questions

Q: accounts you consider most at risk of being materially misstated

A: The accounts , which I consider most at risk of bieng materially misstated are as follows-

Q: Rent'R Cars is a multisite car rental company in the city. It is trying out a new "return the car to…

A: The transportation model is used to calculate the minimum cost of the route by selecting different…

Q: Your deceased client had a gross estate valued at $14 million. His estate includes approximately…

A: The business should be run as per the market conditions, and requirement. The resources for the…

Q: Question 2 Africa World Airline operates in the short-haul flight industry of Ghana. Unlike many of…

A: The mission statement contains either a single sentence or a short paragraph. The mission statement…

Q: Question 9 1. A system which takes resources from its external environment and converts them into…

A: Company- A group of people can organize a legal organization called a corporation to conduct and…

Q: QUESTION 49 Which of the following is most subject to the lemons problem? O credence goods O…

A: Lemon problem refers to a type of adverse selection in which there is a decline in the quality of…

Q: Question 8 Part G A large company is planning to purchase equipment costing $220,000 and will…

Q: Helter Industries, a company that produces a line of women's bathing sults, hires temporaries to…

A: Inventory management includes all the activities that are performed by the inventory manager to…

Q: Questi are long-term, unsecured debt securities.

A: Debentures are long-term debt securities issued by corporations or governments to raise capital.…

Q: e-commerce environment.

A: Digitalization has become the essence of modern business functioning. Today, every business entity,…

Q: question 10.A competitive network results in a more balanced system of dominance compared to a…

A: Competitors are the ones who provide same or near to the same goods and services in the market.…

Q: Problem 11-17 (Static) The National State Bank is trying to make sure that they have enough tellers…

A: Given- Minutes Available = 1 hour = 60 minutesService time = 5 minutes/customerNo. of counter = 8…

Q: COVID-19 in different hospitals nationwide. Below are the costs of production and demands of the…

A: The question presents a scenario where a manufacturer is producing face masks and PPEs for the…

Q: Binary variables are best suited to be the decision variables when dealing with yes-or-no decisions.…

A: Binary variables are thsoe variables that can take up to two ultimate values for example, true or…

Q: Q. 10. Compute the missing term. Dollar Markup Cost $290.25 Selling Price $739.97

A: Markup price refers to the additional amount or percentage added to the cost of a product or service…

Q: A firm has redesigned Its production process so that it now takes 10 hours for a unit to be made.…

A: Find the Given details below: Given details: Time taken for old process 15 Hours Time taken…

Q: Question 3 The Mental Health Parity Act requires the same level of health benefits coverage for…

A: The Mental Health Parity Act is a federal law that requires health insurance providers to provide…

Q: Q.#5 Mr. Hala lives Makkah city. He has to schedule four different meetings with his customers in…

A: - We are solving this by taking 3 distance named as Y1, Y2 & Y3 and R = Y1 + Y2 + Y3 Now we can…

Question

Ch. 19 Q9

Shoney Video Concepts produces a line of video streaming servers that are linked to personal computers for storing movies. These
devices have very fast access and large storage capacity.
Shoney is trying to determine a production plan for the next 12 months. The main criterion for this plan is that the employment level is
to be held constant over the period. Shoney is continuing In Its R&D efforts to develop new applications and prefers not to cause any
adverse feelings with the local workforce. For the same reason, all employees should put in full workweeks, even if that is not the
lowest-cost alternative. The forecast for the next 12 months is
MONTH
January
February
March
April
May
June
FORECAST
DEMAND
600
see
900
600
400
300
MONTH
July
August
Forecast
Beginning inventory
Available production
Ending inventory
Costs
Lost sales
Inventory
Total
September
October
November
December
Manufacturing cost is $200 per server, equally divided between materials and labor. Inventory storage cost is $5 per unit per month
and is assigned based on the ending Inventory level A shortage of servers results in lost sales and is estimated to cost an overall $20
per unit short.
FORECAST
DEMAND
200
The Inventory on hand at the beginning of the planning period is 200 units. Ten labor hours are required per DVD player. The workday
Is eight hours.
Develop an aggregate production schedule for the year using a constant workforce. For simplicity, assume 22 working days each
month except July, when the plant closes down for three weeks' vacation (leaving seven working days). Assume that total annual
production capacity is greater than or equal to total annual demand (1.e., compute workforce level based on annual demand and
annual capacity). (Leave no cells blank - be certain to enter "0" wherever required. Indicate monthly shortages using a negative
ending Inventory level. Round up the "number of workers" to the next whole number and round down your monthly "Available
production" values to the nearest whole number.)
January
200
300
700
600
800
900
February
#I
C
C JU
800
March April
900
600
H
LA
$
May
400
June July August September October November December
300 200
180
Q Search
CHI
****
f5
%
LC
5
200
f6
200
< Previ
4-
0
9 of 14
ly
4
***
m
&
7
0
Total
Total
Next >

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction :

VIEW

Step 2: To find the aggregate production plan for constant workforce :

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

QUESTION 13 (Please use at least four significant figures in your calculations.) $60 S-curve Turntables $160 Hullabaloo Records $40 $260 S-Curve Turntables manufactures turntables, and sells them through Hullabaloo Records, a chain of specialty record stores. For a model year, they will manufacture their newest model of turntable, called "Orbitz", which will be sold through the record stores. It costs $60 for S- Curve to manufacture the turntables, which it then sells to Hullabaloo for $160. Hullabaloo Records then sells the turntables at retail for $260. Whatever doesn't sell gets put on clearance for $40. Demand for the turntable is expected to be normally distributed with a mean of 1833 and a standard deviation of 1092. What is the optimal order amount that will maximize the SUPPLY CHAIN'S expected profit?
Question 4 There are many types of airlines involved in the air cargo business. Think of an airline that you are familiar with. Determine the characteristics of this airline (e.g. aircraft fleet, services provided, products, service quality and service coverage) and its classification by the air cargo business. (10 marks) With reference to the same airline, critique on three (3) key challenges the airline is likely to face in terms of managing its revenue. (15 marks) (a) (b)
Qw.35.
Question 47 Different levels of supply chain analytics include Descriptive, Predictive, Prescriptive, and Cognitive analysis. ents O True O False Question 48 Course ACE) Integrated carriers provide door-to-door service, a consistent schedule of pickup and delivery windows, and standard expedited service through their hub-and-spoke networks. Nonintegrated carriers provide on-demand, air-only service from airport to airport. They rely on freight forwarders or the customer to provide delivery service to and from the airport True O False
The goal of EPR (Extended Producer Responsibility) laws is to: Question 43 options: reduce the amount of potentially dangerous waste in landfills by holding manufacturers accountable for the end-of-life disposal costs. motivate manufacturers to design products that are more easily repaired, reused, and recycled. Neither reduce the amount of potentially dangerous waste in landfills by holding manufacturers accountable for the end-of-life disposal costs nor motivate manufacturers to design products that are more easily repaired, reused, and recycled are correct. Both reduce the amount of potentially dangerous waste in landfills by holding manufacturers accountable for the end-of-life disposal costs & motivate manufacturers to design products that are more easily repaired, reused, and recycled are correct.
Question 3: Jerry has preferences over cats, c, and hats, h, that can be described by u(c, h) = min{2c, 2h}. Sketch the following curves (where pertinent, put c on the horizontal axis and h on the vertical axis): (1) Jerry's price consumption curve as the price of cats p. changes. (2) Jerry's demand curve for cats. (3) Jerry's income consumption curve. (4) Jerry's Engel curve for cats and Jerry's Engel curve for hats.
Question 17 If both potential injurers and potential victims are fully insured, which condition is necessary to produce an efficient level of precautionary effort by both parties? competition between insurers to drive insurance prices down to the expected cost of accidents plus administrative costs O a strict liability rule O punitive damages to discourage reckless behavior O a comparative negligence rule to allocate the damages between the victim and the injurer
Question 16 "USC' STANDS FOR UNIT SHIPPING COST AREA X AREA Y AREA Z SUPPLIES 300 300 PLANT A 600 USC: 5 USC: 7 USC: 7 200 300 PLANT B 500 USC: 4 USC: 2 USC: 8 DEMANDS 300 500 300 WHICH OF THE FOLLOWING IS TRUE ABOUT THE SUPPLY ALLOCATION ABOVE? The allocation of supplies is not yet optimal (i.e., the revenue can be increased) The allocation of supplies is not yet optimal (i.e., the total shipment cost can still be lowered) O The allocation of supplies is optimal (i.e., the total transportation cost cannot be lowered anymore)) O The allocation of supplies is optimal (i.e., the revenue is maximized)
What is section 1981? Question 13 options: A Federal law that complements the Civil Rights Act of 1964 which states, all persons shall have the same right to make and enforce contracts as enjoyed by white citizens. A Federal law that complements the Civil Rights Act of 1964 which states, all persons shall have the same right to make and enforce contracts as enjoyed by non-transgendered citizens. A Federal law that complements to make and enforce contracts as enjoyed by ethnic origins and age groups. None of the above
Q1. Hotel manager Mr. Smith and his resourceful assistant, John, run a 26-room hotel in a little town. A combination of Mr. Smith's friendly attitude and the absence of a respectable hotel in the nearby vicinity imply that Mr. Smith enjoys sufficient demand at his low fare of $159 per night. John notes that some customers will walk into the hotel requesting a room for that evening and they are willing to pay a high fare of $325 per night. John knows this demand is variable. (In reality, this demand is U(4,9)) He suggests some rooms should be kept unsold to the low-fare customers so that they can serve the high-fare customers. a) To maximize profits with John's plan, what is the booking limit that should be set for low fare customers? b) Mr Smith does not like the idea of John and says “we will sell to everyone who reserves in advance and ignore the walk-in demand." If Mr Smith has his way, what will be the hotel's expected revenue? C) John replies, "If you are going to forgo the…
Question A local real estate investor in Kingston is considering three investments: a motel, a restaurant, or a theatre. Profits from the motel or restaurant will be affected by the availability of gasoline and the number of tourist; Profits from the theatre will be relatively stable under any conditions. The following payoff table shows the profit or loss that could result from each investment: Real Estate Investor Payoff Table Payoffs are Profits States of Nature (Gasoline Avaliability) Decision Alternatives Shortage Stable Supply Surplus Motel $8,000 $15,000 $22,000 Restaurant $2,000 $8000 $6,000 Theater $6,000 $6,000 $5,000 If the probability of a shortage of gasoline is 25%, the probability of a stable supply of gasoline is 45% and the probability of a surplus of gasoline is 30%. Using the EMV, What option should the real estate investor choose and what is that optimal expected value? What is the most the real…
QUESTION 15 The Sweet Success Bakery sells 800 cakes at a price of $20 per cake. Its total economic costs for producing 800 cakes are $4,800. The Sweet Success Bakery's economic profits are O $4,800. $11,200. $16,000. indeterminate from this information.