Chat with us, powered by LiveChat Shelby Shelving is a small company that manufactures two types of shelves for grocery stores. Model S is the standard model; Model LX is a heavy-duty version - Wridemy

Shelby Shelving is a small company that manufactures two types of shelves for grocery stores. Model S is the standard model; Model LX is a heavy-duty version

 Unit 2

Case 3.1. Shelby Shelving

Shelby Shelving is a small company that manufactures two types of shelves for grocery stores. Model S is the standard model; Model LX is a heavy-duty version. Shelves are manufactured in three significant steps: stamping, forming, and assembly. In the stamping stage, a large machine is used to stamp (i.e., cut) standard metal sheets into appropriate sizes. In the forming stage, another machine bends the metal into shape. Assembly involves joining the parts with a combination of soldering and riveting. Shelby's stamping and forming machines work on both models of shelves. Separate assembly departments are used for the final stage of production. The file C03_01.xlsx contains relevant data for Shelby. (See Figure 3.38.) The hours required on each machine for each product unit are shown in the range B5:C6 of the Accounting Data sheet. For example, producing one Model S shelf requires 0.25 hour on the forming machine. Both the stamping and forming machines can operate for 800 hours each month. The Model S assembly department has a monthly capacity of 1900 units. The model LX assembly department has a monthly capacity of only 1400 units. Currently, Shelby is producing and selling 400 units of Model S and 1400 units of Model LX per month.

Figure 3.38 Data for Shelby Case

An Excel sheet shows data for the Shelby case, depicting Shelby Shelving data for the current production schedule. There are three columns, with column heads as Model S and Model L X, and they are available for the components Stamping and Forming of Machine requirements in hours per unit. All the values are highlighted. Three columns: Model S and Model L X give information about the current monthly expenditure and the Hours spent in the stamping and forming departments. For the same two models, Stamping and Forming are depicted as Percentages of time spent in departments, along with Unit selling price and Assembly capacity. These values for Unit selling price and Assembly capacity are highlighted. On the right side of the spreadsheet, the values of given monthly overhead cost data are depicted for its components as Stamping, Forming, Model S Assembly and Model L X Assembly for Fixed, Variable S and Variable L X . All the values of this section are highlighteddirectes of Direct materials and direct labor for Model S and Model L X are shown and highlighteheadingdeas well as standardad, Standard costs of the shelves, based on the current production levels. The components of direct labor are Stamping, Forming, and Assembly for Model S and Model L X. All the values in this section are highlighted. Values of Total direct labor for Model S and Model L X are shown, along with overhead allocation. The components of overhead allocation are stamping and forming for Model S and Model L, as shown in X. Total overhead and cost for Model S and Model L X are also depicted at the bottom of the sheet.

Model S shelves are sold for $1800, and Shelby's LX shelves for $2100. Shelby’s operation is relatively small in the industry, and management at Shelby believes it cannot raise prices beyond these levels because of the competition. However, the marketing department believes Shelby can sell as much as it can produce at these prices. The costs of production are summarized in the Accounting Data sheet. As usual, values in blue cells are given, whereas other values are calculated from these.

Management at Shmonth's met to discuss next month’s operating plan. Although the company's products are selling well, the company's overall profitability is poor. Doug Jameson, the plant’s engineer, suggested that the current production of Model S shelves be"cut back. According to Doug, “Model S shelves are sold for $1800 per unit, but ours are $1839. Even though we only have 400 units a month, we’re losing money on each one. We should increase production of Model S.” The controller, Sarah Cranston, disagreed. She said the problem was the Model S assembly department trying to absorb a significant overhead with a small production volume. “The Model S units are contributing to overhead. Even if production doesn’t cover all the fixed costs, we’d be worse off with lower production.”Your job is to deShelby's"  LP model of Shelby’s problem, run Solver, and finally make a recommendation to Shelby management, with a short verbal argument supporting Doug or Sarah..

Unit 3

3. During 2001, many European markets for mobile phones reached saturation. Because of this, mobile phone operators started to shift their focus from growth and market share to cutting costs. One way to do this is to reduce spending on international calls. These calls are routed through network operating companies called carriers. The carriers charge per call-minute for each destination and often use a discount on total business volume to price their services. A mobile phone operator must decide how to allocate destinations to carriers.

V-Mobile, a mobile phone operator in Denmark, must make such a decision for a T-month planning horizon when it has C carriers to choose from, D customers for its customers’ calls, and there are I price intervals for a typical carrier. (The carrier's discounts define a carrier’s discount structure.) The inputs include the following:

The price per call-minute for destination d from carrier c in price interval i in month t

The (forecasted) number of call minutes for destination d in month t

The lower and upper limits for carrier c in price interval i

The lower and upper limits on capacity (number of call-minutes) for carrier c in month t

The penalty per call-minute (to discourage poor-quality options) for carrier c to destination d in month t

V-Mobile wants to find the least-cost way of routing its call minutes through the various carriers. Of course, it hopes to take advantage of the price discounts offered by the carriers.

The file C06_02.xlsx provides input for V-Mobile's version of the problem. This version has 

????

=

2

 , 

????

=

3

 , 

????

=

5

 , and 

????

=

3

 . The decision variables should include the following:

The number of call minutes routed through carrier c to destination d in price interval i in month t

A binary variable for each carrier c and price interval i combination that equals one if the total call minutes for this carrier (over all destinations and months) falls in price interval i, and equals zero otherwise.

Develop an optimization model that helps V-Mobile allocate its international calls cost-efficiently. Then write a brief memo stating.

(1)

How V-Mobile should implement your results for this particular version of the problem, and

(2)

How would the model need to be modified for other potential problem parameters?

Unit 4

In 2001, many European mobile phone markets reached saturation. Because of this, mobile phone operators started to shift their focus from growth and market share to cutting costs. One way to do this is to reduce spending on international calls. These calls are routed through network operating companies called carriers. The carriers charge per call-minute for each destination and often use a discount on total business volume to price their services. A mobile phone operator must decide how to allocate destinations to carriers.

V-Mobile, a mobile phone operator in Denmark, must make such a decision for a T-month planning horizon when it has C carriers to choose from, D customers for its customers’ calls, and there are I price intervals for a typical carrier. (These intervals define a carrier’s discount structure.) The inputs include the following:

The price per call-minute for destination d from carrier c in price interval i in month t

The (forecasted) number of call minutes for destination d in month t

The lower and upper limits for carrier c in price interval i

The lower and upper limits on capacity (number of call-minutes) for carrier c in month t

The penalty per call-minute (to discourage poor-quality options) for carrier c to destination d in month t

V-Mobile wants to find the least-cost way of routing its call minutes through the various carriers. Of course, it hopes to take advantage of the carriers' price discounts.

The file C06_02.xlsx provides inputs for V-Mobile's version of the problem. This version has 

????

=

2

 , 

????

=

3

 , 

????

=

5

 , and 

????

=

3

 . The decision variables should include the following:

The number of call minutes routed through carrier c to destination d in price interval i in month t

A binary variable for each carrier c and price interval i combination that equals one if the total call minutes for this carrier (over all destinations and months) falls in price interval i, and equals zero otherwise.

Develop an optimization model that helps V-Mobile allocate its international calls cost-efficiently. Then write a brief memo stating.

(1)

How V-Mobile should implement your results for this particular version of the problem and(2)

How would the model need to be modified for other potential problem parameters?

Accounting Data

Shelby Shelving Data for Current Production Schedule
Machine requirements (hours per unit) Given monthly overhead cost data
Model S Model LX Available Fixed Variable S Variable LX
Stamping 0.3 0.3 800 Stamping $125,000 $80
Chris Albright: Overhead per unit of model S
$90
Chris Albright: Overhead per unit of model LX
Forming 0.25 0.5 800 Forming $95,000 $120 $170
Model S Assembly $80,000 $165 $0
Model S Model LX Model LX Assembly $85,000 $0 $185
Current monthly production 400.0 1400.0
Standard costs of the shelves — based on the current production levels
Hours spent in departments Model S Model LX
Model S Model LX Totals Direct materials $1,000 $1,200
Stamping 120.0 420.0 540.0 Direct labor:
Forming 100.0 700.0 800.0 Stamping $35 $35
Forming $60 $90
Percentages of time spent in departments Assembly $80 $85
Model S Model LX Total direct labor $175 $210
Stamping 22.2% 77.8% Overhead allocation
Forming 12.5% 87.5% Stamping $149 $159
Forming $150 $229
Unit selling price $1,800 $2,100 Assembly $365 $246
Total overhead $664 $635
Assembly capacity 1900.0 1400.0 Total cost $1,839 $2,045

LP Model

image1.png

image2.png

,

Data

Carrier selection for telecommunication company with volume discounts
Albright: See "Selecting Telecommunication Carriers to Obtain Volume Discounts" in Interfaces, Vol. 35, No. 2, 2005.
Inputs
Price intervals
Lower limit Upper limit
Carrier 1 0 2000
2000 4000
4000 50000
Albright: The upper limit for each 3rd price interval is essentially infinite, so any large number here will suffice.
Carrier 2 0 2500
2500 5000
5000 50000
Carrier 3 0 2000
2000 3500
3500 50000
Unit prices Month 1 Month 2
Dest 1 Dest 2 Dest 3 Dest 4 Dest 5 Dest 1 Dest 2 Dest 3 Dest 4 Dest 5
Carrier 1 9 12 15 10 15 9 12 15 10 15
8 10 13 8 13 8 10 13 8 13
7 8 10 5 10 7 8 10 5 10
Carrier 2 10 13 17 11 16 10 13 17 11 16
9 11 15 9 14 9 11 15 9 14
8 9 13 5 12 8 9 13 5 12
Carrier 3 8 14 17 12 14 8 14 17 12 14
7 12 13 10 12 7 12 13 10 12
6 10 9 8 9 6 10 9 8 9
Penalties per call-minute Lower and upper bounds on capacity
Month 1 Month 2 Month 1 Month 2
Dest 1 Dest 2 Dest 3 Dest 4 Dest 5 Dest 1 Dest 2 Dest 3 Dest 4 Dest 5 Lower bound Upper bound Lower bound Upper bound
Carrier 1 2 2 Carrier 1 0 2000 0 2000
Carrier 2 2 2 Carrier 2 500 2000 500 2000
Carrier 3 3 3 Carrier 3 0 2500 0 2500
Forecasted volumes 500 1000 800 1200 900 700 1000 600 1500 700

image1.png

image2.png

image3.png

,

Data

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order



Student CPA? Quant? Female? Minority? Foreign? Key to 0-1 variables
1 0 0 1 0 0 1 = Yes
2 0 0 0 0 0 0 = No
3 1 0 1 0 0
4 0 0 1 0 0
5 0 1 0 0 0
6 1 0 0 0 1
7 0 1 0 1 0
8 0 1 0 0 0
9 0 0 0 0 1
10 0 1 0 0 1
11 1 0 0 0 1
12 0 0 0 1 0
13 0 1 1 0 0
14 1 0 0 0 0
15 0 0 0 0 0
16 0 1 0 0 0
17 0 1 0 0 0
18 0 0 0 0 0
19 0 0 1 0 0
20 0 1 1 0 1
21 0 1 0 1 0
22 0 1 0 1 1
23 0 0 0 0 0
24 0 0 0 0 0
25 1 0 0 0 0
26 0 1 0 0 1
27 1 0 0 1 0
28 0 0 1 1 1
29 0 0 0 1 1
30 0 0 1 0 1
31 1 0 0 0 0
32 0 0 0 0 0
33 0 0 0 0 0
34 1 0 1 0 0
35 0 0 0 0 0
36 1 0 1 0 1
37 1 0 1 0 0
38 0 0 0 0 0
39 0 0 0 1 0
40 0 0 1 1 0
41 0 0 0 0 0
42 0 0 0 0 0
43 0 0 1 0 0