Preview

Office Equipment Inc Case Problem

Powerful Essays
Open Document
Open Document
1639 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Office Equipment Inc Case Problem
LP8 ASSIGNMENT
DISTRIBUTION SYSTEM DESIGN

By:
Jeffrey L. Blake
Course:
MT4210 Quantitative Analysis
Instructor:
Paul Larson
Distribution System Design

1. If the company does not change its current distribution strategy, what will its distribution costs be for the follow quarter?

Original shipping plan model

MIN 3.2x1+2.2x2+4.2x3+3.9x4+1.2x5+0.3x6+2.1x7+3.1x8+4.4x9+2.7x10+4.7x11+3.4x12+
2.1x13+2.5x14

DISTRIBUTION CONSTRAINTS 1. x1+x2+x3≤30,000 2. x4+x5≤20,000 3. –x1+x6+x7+x8+x9=0 4. –x2-x4+x10+x11+x12=0 5. –x3-x5+x13+x14=0 6. x6=3600 7. x7=4880 8. x8=2130 9. x9=1210 10. x10=6120 11. x11=4830 12. x12=2750 13. x13=8580 14. x14=4460

I used this distribution model because the question states that the company in not changing its current distribution strategy. Constraints 1-2 are the number of units that the two plants are able to produce. Constraints 3-5 are transshipment constraints; they guarantee that the number of units shipped into the distribution center is equal to the number shipped out. Constraints 6-14 are the number of units demanded at each customer zone and are in place to guarantee the demand is satisfied. Now to show how to calculate the totals we must set up the model to show no limitations as the problem is saying. To set that up I am going to list the new formulas without limitations.
MIN
3.2x1+2.2x2+4.2x3+3.9x4+1.2x5+0.3x6+2.1x7+3.1x8+4.4x9+2.7x10+4.7x11+
3.4x12+2.1x13+2.5x14+6.0x15+5.2x16+5.4x17+4.5x18+6.0x19+3.3x20+2.7x21+
5.4x22+3.3x23+2.4x24

S.T. (subject to):
1. x1+x2+x3≤30,000
2. x4+x5≤20,000
3. –x1+x6+x7+x8+x9+x15=0
4. –x2-x4+x10+x11+x12+x16+x17+x18+x19+x20+x21=0
5. –x3-x5+x13+x14+x22+x23+x24=0
6. x6+x16=3600
7. x7+x17=4880
8. x8+x18=2130
9. x9+x19=1210
10. x10+x15+x22=6120
11. x11+x23=4830
12. x12+x24=2750
13. x13+x20=8580
14. x14+x21=4460

If Darby keeps the current distribution plan, the total cost will be $620,770 for
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Case 3 Filmore furniture Group 2
    • 1527 Words
    • 6 Pages

    Case 3 Filmore furniture Group 2

    Filmore Furniture was incorporated by Mr. Filmore in the early 70s, he was the only owner but later on he sold his business…

    • 1527 Words
    • 6 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Commercial Fixtures Inc Case
    • 1177 Words
    • 5 Pages

    Commercial Fixtures Inc Case

    a) What does Commercial Fixtures do? What is their competitive position in the market place?…

    • 1177 Words
    • 5 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Case 13-4 Hemo Tech
    • 659 Words
    • 3 Pages

    Case 13-4 Hemo Tech

    ASC 605 -25, Revenue Recognition: Multiple-Element Arrangements (ASC 605 -25) (as updated by ASU 2009 - 13, Multiple-Deliverable Revenue Arrangements (ASU 2009-13))…

    • 659 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Competition Bikes Budget Analysis
    • 1957 Words
    • 8 Pages

    Competition Bikes Budget Analysis

    The cost of distribution network support needs to be adjusted. A distribution network is everything involved in getting the product from the manufacturer to the retailer. The estimated expense for year nine is $50,830 which is equal to the year eight dollar amount however, year nine forecasted 110 more units sold. The cost per unit of distribution network support is equal to $14.95 when comparing the previous three years data. This meant the forecasted budget for an estimated 3510 units should be set to $52,474.50.…

    • 1957 Words
    • 8 Pages
    Better Essays
    Read More
  • Good Essays

    Mat 540 Stateline shipping
    • 1018 Words
    • 5 Pages

    Mat 540 Stateline shipping

    Here the demand constraint + + ++ + ≤ 65 represents the number of barrels transported to the waste disposal site Whitewater from all the six plants. The barrel of wastes that can accommodate in the waste disposal site Whitewater is limited to 65 barrels. The demand constraints are ≤ inequalities because the total demand (65+80+105) = 250 exceeds the total supply (26+42+53+29+38) = 223.…

    • 1018 Words
    • 5 Pages
    Good Essays
    Read More
  • Better Essays

    Comptronix Corporation Case 4.2
    • 1087 Words
    • 5 Pages

    Comptronix Corporation Case 4.2

    The audit risk model is composed of four risks. The planned detection risk is a factor of inherent risk, control risk, and acceptable audit risk. Planned detection risk is the risk the auditor fails to detect misstatements and will increase or decrease dependent on the level of risk in the other three factors. If the auditor determines it is expected that misstatements is highly likely than inherent risk increases and create a higher demand for evidence. As the same with control risk, the weaker the internal controls the higher the planned detection risk will be. Acceptable audit risk on the other hand the lower the risk the lesser amount of evidence will be needed.…

    • 1087 Words
    • 5 Pages
    Better Essays
    Read More
  • Good Essays

    WGP chemical company
    • 518 Words
    • 3 Pages

    WGP chemical company

    In order to calculate the total distribution cost, carrying cost must be calculated. Inventory carrying cost rate was given as 18%. The formula is…

    • 518 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    American Home Product (AHP) Case
    • 1291 Words
    • 6 Pages

    American Home Product (AHP) Case

    American Home Products (AHP) has established a strong track record of revenue growth and return on equity over the past decade, producing a host of products in four separate business lines: prescription drugs, packaged drugs, food products, and housewares/household products. AHP’s distinctive culture emphasizes conservatism, cost control and risk aversion. AHP’s corporate structure also concentrated most decision-making authority with the incumbent chief executive, William F. Laporte. This approach and the results that followed has led to popularity amongst investors, with Laporte had stating that “a corporation’s primary mission is to make money for its stockholders and maximize profits by minimizing costs.”…

    • 1291 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Good Essays

    Ncb Office Products Inc. Case Analysis
    • 1822 Words
    • 8 Pages

    Ncb Office Products Inc. Case Analysis

    NCB is a manufacturer and distributer of a wide range of office products. In Canada, NCB uses several distributers in different regions. One of the major distributers is Harrison Stationary and Office Supply LTD. Harrison had distributed NCB’S products for over 50 years and NCB was the largest supplier of Harrison. In January 2003 Harrison was acquired by the president of the company and four senior officers. Most of the acquisition cost was financed by bank loans. Since the acquisition, Harrison had difficulties to pay NCB for the goods and the account receivable reached to unacceptable level. In September 2005 the Harrison account was 156 days old and amounted to $ 4.4 million. In addition, NCB’s credit management tried to receive financial information from Harrison’s management without great success. After 14 months of avoiding the requests of NCB’s credit department, Harrison’s management released the financial statements. The financial statements of Harrison revealed a very risky financial situation. The company had substantial losses and had an equity deficit position. Tutlte, NCB’s credit manager recommended to stop shipments to Harrison immediately and let them get bankrupt. However, Pam Bookman, vice-president sales had a different opinion. She was afraid to lose market share because the company didn’t have a contingency plan for another distributer. Now, NCB’s management is facing a big dilemma concerning this issue and must decide how to handle this situation. MNC’s decision will have a great impact on both companies.…

    • 1822 Words
    • 8 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    DANSHUI PLANT NO 2
    • 428 Words
    • 2 Pages

    DANSHUI PLANT NO 2

    3. What should be the total expected cost per unit if all manufacturing and shipping overhead (both variable and fixed) were allocated to planned production? What was the actual cost per unit of production and shipping?…

    • 428 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Quantitative Analysis for Management
    • 368 Words
    • 2 Pages

    Quantitative Analysis for Management

    Raptor Fuels produces three grades of gasoline Regular, Premium, and Super. All of these are produced by blending two types of crude oil Crude A and Crude B. The two types of crude contain specific ingredients which help in determining the octane rating of gasoline. The important ingredients and the costs are contained in the following table:…

    • 368 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Gadget Toys Case Write-Up
    • 540 Words
    • 3 Pages

    Gadget Toys Case Write-Up

    Gadget Toy Company is faced with a choice between two options to reduce project time for their new toy line. Gadget must cut down project time in order to meet their Christmas deadline that is 19 weeks away. Analysis shows that there are two critical paths for the current process, which is 20 weeks long and includes the following critical activities: obtain funding approval (A), finalize engineering (B), build dies/tools (D), raw material delivery (K), initial production run (L), ship product (M), train workers (F), and de-bug process (G). See figure below.…

    • 540 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Math Ia
    • 785 Words
    • 4 Pages

    Math Ia

    Introduction: In this task I will consider a set of numbers that are presented in a symmetrical pattern and try to find a general equation to find the elements in the [pic]row.…

    • 785 Words
    • 4 Pages
    Good Essays
    Read More
  • Powerful Essays

    Ski Equipment Inc. Case
    • 2016 Words
    • 7 Pages

    Ski Equipment Inc. Case

    Dan Barnes, financial manager of Ski Equipment Inc. (SKI) is anxious that the Company’s founder recently sold his 51% controlling block of stock to Kent Koren, who is a big fan of EVA (Economic Value Added). Koren rewards managers handsomely if they create value, but those whose operations produce negative EVAs are soon looking for work. Koren frequently points out that if a company can generate its current level of sales with fewer assets, it would need less capital. Shortly after he took control of SKI, Koren met with SKI’s senior executives. He noted that SKI’s designs of skis, boots, and clothing are acclaimed throughout the industry but that something is seriously amiss elsewhere in the company. Costs are too high, prices are too low, or the company employs too much capital; and he wants SKI’s managers to correct the problem. Barnes has long felt that SKI’s working capital situation should be studied—the company may have the optimal amounts of cash, securities, receivables, and inventories; but it may also have too much or too little of these items. Barnes also knows that decisions about working capital cannot be made in a vacuum. However, lower raw materials inventories might lead to production slowdowns and higher costs, while lower finished goods inventories might lead to the loss of profitable sales. So before inventories are changed, it will be necessary to study operating as well as financial effects. The situation is the same with regard to cash and receivables.…

    • 2016 Words
    • 7 Pages
    Powerful Essays
    Read More

Related Topics