Preview

Sutdent

Powerful Essays
Open Document
Open Document
3131 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Sutdent
Table of contents

SECTION 1- Logistics Decisions at VXL automotive 1 Exhibition 1 1 Exhibition 2 6 Exhibition 3 9 Section 2- Sheffield City Council Waste Management 10 Section 3- Reflection question 15

SECTION 1- Logistics Decisions at VXL automotive

Exhibition 1

1. Identify and explain all the constraints

In this report, city model is called as “C” and family model is simplified as “F”.

Owing to the head of Logistic and Supply Production Planning team has mentioned that the figure of car production in February should not over the forecast of March 2013 multiplied by 1.06 (corrective factor). Meanwhile, the figure must not lower than number in February.

3514 ≤ C ≤ 3784

Also, the amount of the Family model should higher than 1200.

1200 ≤ F

In terms of passenger doors:

City model has 2 doors while family mode has 4 doors and the contract indicates that the minimum number is 6000 doors for both figures whist the maximum is 18000.

6000 ≤ 2C+4F ≤ 18000

Turning to the assemble time:

Family model needs 20 hours to assemble a car whist the city one takes 15. The total worker is 650 people and each people work 40 hours per week, also this number should turn into monthly which means the result multiply 4. The outcome multiplies the absenteeism that is 4%.

Total work time:

650*40*4*(1-4%)= 99840

20F/ car family car
15C/car city car

20F + 15C ≤ 99840

The profit margin of family model is higher 15% than city one, so the formula can be assumed as F*115%

Max profit margin =F+C

Max profit margin= F115%+C

2. Solve it by using the graphical method

Chart 1
Chart 1

So the optimal product mix is: F = 2154, C = 3784

Max profit is 2154*115%+3784= 6261

3. Check the results by using the Excel Solver:

Chart 2
Chart 2

After predicted the De-seasonal series, the outcome can be list as below

De-seasonal series | 49 | 3540 | 50 | 3553 | 51 | 3565 | 52 | 3578 |

You May Also Find These Documents Helpful

  • Good Essays

    Acct 505 Course Project

    • 1431 Words
    • 6 Pages

    | BE Passenger Cars = BE Passengers / (Capacity x Load Factor) = 35,000 / (90 x 70%) = 556…

    • 1431 Words
    • 6 Pages
    Good Essays
  • Good Essays

    Math203

    • 385 Words
    • 2 Pages

    Model 1: Run a full model for profit that includes both tenure and site location related variables. Tenure related variables are MTenure and CTenure. Site location related variables are population, number of competitors, street level visibility, pedestrian access, type of neighborhood, and whether a store staysDefinitions of the different variables in the data are provided in the case itself. Briefly discuss the summary statistics presented in Exhibit 3 in Store24A and Exhibit 2 in Store24B. Use a maximum of 2 slides for this discussion. In your opinion, what do the summary statistics tell us about Store24?…

    • 385 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    | (TCO F) The size of the labor force in a community is 1,000, and 850 of these folks are gainfully employed. In this community, 50 people over the age of 16 do not have a job and are not looking for work. In addition, 80 people in the community are under the age of 16. The unemployment rate is ______.…

    • 1825 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    Looking over the Constructit Company they have 1000 employees working for them. The people at Constructit are willing to pay a maximum premium of $4,000 per person. The company has 550 men working for them and 450 women working for them. Out of all the employees 32% of them are involved in a great deal of physical activity during their work day,25% have moderate…

    • 860 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Programing Problems

    • 721 Words
    • 3 Pages

    RegularHours * HourlyRate + OvertimeHours * (HourlyRate * 1.5) End Gross Pay module Tax Module Tax=GrossPay*.30 End Tax Module Net Pay Module NetPay = GrossPay –Tax – Parking…

    • 721 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    QLT1 task 3

    • 296 Words
    • 1 Page

    A couple is comparing two day cares to find the best option for their 5 year old son. A home-based daycare charges a flat rate of $5 per hour. A center-based daycare charges a fixed rate of $185 per week, providing 40 hours of childcare. Above 40 hours, the center-based daycare then charges a fixed rate of $12 per hour. The couple determines that the driving distance to each daycare is the same, thus driving expenses do not need to be considered. will require 50 hours of childcare per week and are looking for the cheapest daycare, as they are soon expecting their second child.A couple is comparing two daycares to determine the best option for their 1 year old son. A home-based daycare charges a flat rate of $15 per hour. A center-based daycare charges a fixed rate of $185 per week, providing 40 hours of childcare. Above 40 hours, the center-based daycare then charges a fixed rate of $8 per hour. The couple determines that the driving distance to each daycare is the same, thus driving expenses do not need to be considered. The couple will require 50 hours of childcare per week and are looking for the cheapest daycare, as they are soon expecting their second child.A couple is comparing two daycares to determine the best option for their 1 year old son. A home-based daycare charges a flat rate of $5 per hour. A center-based daycare charges a fixed rate of $185 per week, providing 40 hours of childcare. Above 40 hours, the center-based daycare then charges a fixed rate of $8 per hour. The couple determines that the driving distance to each daycare is the same, thus driving expenses do not need to be considered. The couple will require 50 hours of childcare per week and are looking for the cheapest daycare, as they are soon expecting their second…

    • 296 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    Sutterwhite

    • 758 Words
    • 4 Pages

    This case talked about the difference a good personality could make in being an effective manager. In the case Wallace was a manager whom had a horrible personality. Apparently self centered he found a way to blame every problem on someone or something else other than himself. When trying to improve Wallace's success boss a former store manager, Sutterwhite observed his interactions with customers and decided to inform him of the things she observed and put fire under his butt by saying that he has three months to improve of he will be replaced.…

    • 758 Words
    • 4 Pages
    Good Essays
  • Good Essays

    HW 2

    • 711 Words
    • 3 Pages

    2. Assume some guy named Spano and a woman named Bagley are stranded on an island. Two tasks must be done: fishing and building shelters. Assume that Bagley can catch one fish every 10 hours and build one thatched hut every 20 hours. While Spano (who is a bit on the clumsy side) can catch one fish every 15 hours and build a thatched hut every 45 hours. Now assume that during the year both Bagley and Spano each work 108,000 minutes.…

    • 711 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Seligram Inc.

    • 934 Words
    • 4 Pages

    Consultant: Direct Labor Hours x (100% + 20%) + Main Room Machine Hours x 63.34 + Mechanical Room Hours x 112.63…

    • 934 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Cost and Store

    • 925 Words
    • 4 Pages

    David Green is considering his operating statement for 2010, which is displayed in the table below. David is the manager of store number 88, where he began as one of the staff 6 years ago, and through hard work has risen to become manager of the store. The operating report shows his budgeted performance for the year and the actual results, showing a net improvement of 9% over budget--$405. While his results are positive, the small improvement over the budget does not qualify David for the bonus program which awards a $3,000 bonus for store managers who improve their performance over that of the budget by 20% or more. David manages one store in a 110 store chain of pet grooming stores owned by Pet Groom & Clean Company (PG&C). As for other PG&C stores, his store is open Monday through Saturday each week; the only service provided at the store is a service in which a pet, dog or cat, is groomed and cleaned, typically while the customer waits. The budgeted price for the service at the beginning of 2010 was $25. Budgeted variable costs were $2 for materials and $9 labor cost per service, as well as other variable costs of $1.50 per service. Materials are purchased by local store managers, and all staff are hired and supervised by the local store managers. Other budgeted and actual information for 2010 are shown in the table below. David is an ambitious and hard working manager, who has applied himself to the job and has looked for different ways to attract customers and to reduce costs. For example, he noticed that most of the company’s customers brought their pets in on Friday, Saturday, and Monday, and the number of customers was significantly lower on Tuesday through Thursday. In fact, David budgeted that 80% of total demand for 2010 would be in the Friday-Monday period, and only 20% would be in the…

    • 925 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Yankee Fork and Hoe face some major issues in production forecasting and communication between departments. Communication is the key factor leading to the problems in forecasting and production. In the current system the marketing department sends down an inflated forecast to the production department, and to lessen the blow of inventory costs, the production department reduce the forecast by 10%. There is no coordination between the two therefore, the firm is trying to fix past problems by inflating forecasts, instead of forecasting future demand.…

    • 435 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Family System in Pakistan

    • 527 Words
    • 3 Pages

    Conversely in the recent years, urbanization has directed to the alterations and amendments in the existing family system, in larger cities. Moreover, the realism of urbanization will make the social units living together to get less exerted and large nuclear group. This method of practice will commonly be practiced and determined in developing countries. As known well that Karachi is the biggest city in Pakistan, the city has observed and on-looked the most avid impingement of urbanization. Also, people can clearly get to know and study the comparable variations in the family system.…

    • 527 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Solution Guide

    • 320 Words
    • 2 Pages

    (1 - T)(CFt - ΔEt) + TDt = (1 - 0.35)($135,000 - $0) + 0.35 x ($1,000,000 - $250,000) / 10…

    • 320 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    paper

    • 1313 Words
    • 6 Pages

    The theory suggests that consumption (Y) depends on income (X); hence, econometric model may be specified, as follows.…

    • 1313 Words
    • 6 Pages
    Satisfactory Essays