Preview

Executive Summary of Shelby Shelving

Satisfactory Essays
Open Document
Open Document
885 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Executive Summary of Shelby Shelving
I pledge my honor that I have not violated the Honor Code during the preparation of this assignment.

Assignment 2 Shelby Shelving
From Ayşe Gül Vural
Date March 02,2015

Executive Summary
Shelby Shelving is a manufacturing firm who produces shelves for grocery stores. They have two types of shelves named Model S and Model LX. These two models have three main steps in production which are: Forming, Stamping and Assembly. Forming and Stamping departments can produce both models on same line whereas Assembly lines are different for each model. Firm’s problem is to determine how much to produce monthly Model S and Model LX in order to maximize the profit. The decision depends on the optimal quantity that must be produced for each model. The key issue is the marketing department of the company and the controller of the firm have conflicts about Model S. The marketing department think that they should cut back Model S production because its’ cost is higher than the selling price which make them having losses but Controller disagreed and he argues that they will be worse-off with lower production because Model S has a contribution to make overhead. The solution is the optimal quantity to produce each model at which the total profit will be the maximum.

Model
Decision: How much to produce Model S and Model LX
Objective: To find optimal production for each Model which gives the maximum profit by using resources
Assumptions:
Machine requirements hours per unit: Model S: (Stamping-0,3/Forming-0,25) Model LX: (Stamping-0,3/Forming-0,5) are given and known,
Hours spent in departments: Model S: (Stamping-570hrs/Forming-475hrs) Model LX: (Stamping-195hrs/Forming-325hrs),
Unit Selling Price: Model S: $1800 and Model LX: $2100 are given and constant
Assembly Capacity: Model S: 1900 units and Model LX: 1400 units
Forming and Stampnig Capacities: 800hrs
Current Montly production: Model S:400 and Model LX:1400 and accounting data based on this production level is also

You May Also Find These Documents Helpful

  • Satisfactory Essays

    WGU EGT1 Task 1

    • 746 Words
    • 3 Pages

    Profit maximization in terms of total revenue to total cost can be approached in two different ways. The first is to take total revenue and total cost for a time period and subtract total cost from total revenue for each unit produced to determine how many units produced would yield the highest profit. To do this in this scenario I have illustrated it in the chart below.…

    • 746 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Busn312 Hw3A

    • 727 Words
    • 3 Pages

    a.|Find the best decision variable values that satisfy all constraints.| b.|Find the values of the decision variables that use all available resources.| c.|Find the values of the decision variables that satisfy all constraints.| d.|None of the above.| ____B 3. Limited resources are modeled in optimization problems as a.|an objective function.| b.|constraints.| c.|decision variables.| d.|alternatives.| __A__ 4. Retail companies try to find a.|the least costly method of transferring goods from warehouses to stores.| b.|the most costly method of transferring goods from warehouses to stores.| c.|the largest number of goods to transfer from warehouses to stores.| d.|the least profitable method of transferring goods from warehouses to stores.| _B___ 5. Most individuals manage their individual retirement accounts (IRAs) so they a.|maximize the amount of money they withdraw.| b.|minimize the amount of taxes they must pay.| c.|retire with a minimum amount of money.| d.|leave all their money to the government.| _A___ 6.…

    • 727 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    “I pledge my honor that I have not violated the Olin School Honor Code during this examination. I have completed this exam individually and have not and will not discuss it with anyone. I have not used any external materials, texts, the Internet or any other sources of information other than my course materials.”…

    • 599 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Hamptonshire Express Case

    • 632 Words
    • 3 Pages

    b. The optimal stocking quantity differs from problem #2 because Ralph is incurring the cost of overstocking, which changes the critical ratio from .8 in problem #2 to .2. Because of the critical ratio change, Anna’s profit decreases as Ralph’s increases. This is consistent with the Newsvendor Model, which gives Cu=.2, Co=.8, for a critical ratio of .2. Using the formula in the spreadsheet, Q*=NORM.INV(.2,600,100)=515.837, gives the optimal stocking quantity of 516.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Best Essays

    Bus 599 Assign 2

    • 1358 Words
    • 6 Pages

    The fictitious business in this assignment is named TopShop, which is an American multinational retailer with its main headquarters in New York. It is a high end fashion brand that specializes in fashion clothing, shoes, make-up and accessories. Currently, TopShop has 150 workers for its factory in New Jersey, and has hired a consultant to offer some advice that could help it make a decision as to whether it should shut down completely or continue operations. In addition, TopShop has 100 workers that produce 6,000 units of output per month (working 20 days / month). The daily wage (per worker) is $70, and the price of the firm’s output is $32. The cost of other variable inputs is $2,000 per day. The firm’s fixed cost is “high enough” so that the firm’s total costs exceed its total revenue. The marginal cost of…

    • 1358 Words
    • 6 Pages
    Best Essays
  • Good Essays

    a. Using solver to solve the embedded model in the Excel sheet or by trying different values for h the optimum value will be obtained as “h=4”…

    • 956 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Week 2 Quiz

    • 1824 Words
    • 8 Pages

    2.What are two ways for a competitive firm to determine the optimal level of production, that is, the level of production that will maximize profit or minimize losses? A. B. C. D. Comparing total revenue to total cost or marginal revenue to marginal costs Comparing average revenue to average costs or marginal revenue to marginal costs Comparing average variable costs to price or marginal revenue to price Comparing total revenue to average variable costs or price to average variable costs…

    • 1824 Words
    • 8 Pages
    Powerful Essays
  • Powerful Essays

    I certify that I have observed all the rules of Academic Integrity while taking this examination.…

    • 1644 Words
    • 7 Pages
    Powerful Essays
  • Better Essays

    A master production schedule is used by business organizations as a metric to ascertain whether or not their production (outputs) meets their supply demands (inputs). There are times when a business wants to have a surplus and at others letting inventory dwindle to smaller numbers is optimal. The idea is to ensure that customers get their orders in a timely manner to retain loyalty, maximize profits, and reduce overhead and direct costs. The Realco Breadmaster Company has a new bread maker in the hopes of increasing their revenue. In question is the cost and efficiency of the new bread maker. The owner of Realco, Johnny Chang, wants a Master Production Schedule (MPS) designed.…

    • 2134 Words
    • 9 Pages
    Better Essays
  • Good Essays

    Rock "N" Rap

    • 597 Words
    • 3 Pages

    Explain how you found an answer to Question 3 and why you think your answer gives the maximum profit. I know this because this is the highest point in the feasible region. I it’s hard to tell exactly just by graphing so the problem must be solved algebraically. I…

    • 597 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    802.21

    • 2871 Words
    • 12 Pages

    I pledge on my honor that I have not given or received any unauthorized assistance on this assignment, that my paper contains no plagiarized material, and that I have made every effort to cite sources properly.…

    • 2871 Words
    • 12 Pages
    Powerful Essays
  • Good Essays

    Adecco Writeup

    • 670 Words
    • 2 Pages

    I pledge my honor that I have not violated the Honor Code in preparation of this case…

    • 670 Words
    • 2 Pages
    Good Essays
  • Good Essays

    JGT Task 2

    • 1850 Words
    • 6 Pages

    Alistair Wu has requested that I look at what the lowest shipping schedule and cost can be based on data that he has provided. He wants to know what the lowest possible cost of shipping will can be. Mr. Wu is also considering increasing production at the Shanghai factory from 1,300 to 2,800 units, and wants to ensure that this growth will be an affordable choice. The first chart that was given lists the factory capacity and what each warehouse demand is. The second chart lists the price of shipping from each factory to each warehouse. The chart looks at the demand in the warehouses as well as the cost to ship there from each factory. It then generates a cost effective shipping plan to ship products to the warehouse with least shipping expense and fills those warehouses first. It then allocates additional products to other warehouses that have higher shipping prices. This is evident with Shuzworld H and Shuzworld F, the program ships the most products to the lower priced warehouses 1 and 3. Warehouse 1 need 2,500 units but Shuzworld F only produces 2,200 units. That means Warehouse 1 will take all off the units from Shuzworld F and still have a demand of 300 units. Warehouse needs 1,800 units and Shuzworld H produces 2,300 units. This means Warehouse 3 will receive all of its units from Shuzworld H and Shuzworld H will still have an excess of 500 units.…

    • 1850 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Henry Clements Car rental

    • 453 Words
    • 4 Pages

    From this data, as well as the data given on manufacturing methods and hours per method, a solution could be found utilizing the linear programming method of analysis. To analyze the data, the actual profit on each material was first calculated. This was done by taking the selling price and subtracting each cost associated with the given material. The results are $34.00 for the 75C, $30.00 for the 33C, $60.00 for the 5X, and $25.00 for the 7X. The next step was to determine how many constraints would be part of the analysis. There was determined to be 10 constraints in the analysis, 4 for the April orders, 4 for the manufacturing methods and 2 for the minimum orders promised by Vivian. With this data, the amount of each product to be produced to maximize profit for April could be determined. The results can be seen in Table 3.…

    • 453 Words
    • 4 Pages
    Satisfactory Essays