The problems that are to be solved in excel are attached.

Answered Same DayDec 14, 2021

FS1

Problem 1. Par, Inc. is a small manufacturer of golf equipment. They decided to move into the market of standard and deluxe golf bags. Par's distributor has agreed to buy all the golf bags Par produces over the next three months. The manufacturing department determined that each golf bag produced will require the following operations:

1. Cutting and dyeing the material

2. Sewing

3. Finishing (inserting um

ella holders, club separators, etc.)

4. Inspection and packaging

The production time requirement (in hours) and the available time in the next three weeks (also in hours) for each type of operation are presented in the template below.

The profit per a standard bag is $10.00 and for each deluxe bag is $9.00.

Develop a model to determine the number of standard bags and the number of deluxe bags to produce in order to maximize total profit with the condition that number of standard bags produced should be at least twice as much as number of deluxe bags produced.

Production Time (Hours)

Operation Standard Deluxe

Cutting and Dyeing 0.700 1.000

Sewing 0.500 0.833

Finishing 1.000 0.667

Inspection and Packaging 0.100 0.250

Profit Per Bag $10.00 $9.00

Model

Standard Deluxe

Bags Produced 540.0 252.0

Operation Hours Used Hours Available

Cutting and Dyeing 630.00 <= 630

Sewing 480.00 <= 600

Finishing 708.00 <= 708

Inspection and Packaging 117.00 <= 135

Total Profit 7668.00

FS2

Problem 2. Wheat is harvested at farms in Ne

aska and Colorado before being shipped to the three grain elevators in Kansas City, Omaha, and Des Moines. The amount of wheat harvested at each farm is 320 tons. The wheat is then shipped from grain elevators to the mills in Chicago, St. Louis, and Cincinnati. Each mill demands the following number of tons of wheat:

Chicago - 200, St. Louis - 100, and Cincinnati - 300. The unit shipping cost (i.e., cost per ton) between points are given in the table below. The maximum capacities of the three grain elevators are: Kansas City - 160, Omaha - 185, Des Moines - 285.

Create a model to determine the best shipment plan, which meets all requirements and minimizes the total shipment cost.

Chicago St. Louis Cincinnati Supply

Kansas City 6 8 10 150

Omaha 7 11 11 175

Des Moines 4 5 12 275

Demand 200 100 300

Chicago St. Louis Cincinnati Supply Capacity

Kansas City 0 0 150 150 150

Omaha 25 0 150 175 175

Des Moines 175 100 0 275 275

Demand 200 100 300

Requirements 200 100 300

Total 4525

FS3

Problem 3. Probability and Probability Distributions

a)The figure shows a box with 8 letters. Some letters are repeated. Suppose 4 letters are drawn at random from the box one-by-one without replacement.

What is the probability of the outcome HULU, with the letters chosen in exactly the order given? b) The statistical analysis of the long-distance calls made from the headquarters of the Bricks and Clicks Computer Corporation indicates that the length of calls is normally distributed with µ = 228 seconds and σ = 37 seconds. What is the probability that a randomly selected call lasts:

a) more than 205 seconds?

b) no more than 184 second?

c) exactly 192 seconds?

d) between 183 and...

Problem 1. Par, Inc. is a small manufacturer of golf equipment. They decided to move into the market of standard and deluxe golf bags. Par's distributor has agreed to buy all the golf bags Par produces over the next three months. The manufacturing department determined that each golf bag produced will require the following operations:

1. Cutting and dyeing the material

2. Sewing

3. Finishing (inserting um

ella holders, club separators, etc.)

4. Inspection and packaging

The production time requirement (in hours) and the available time in the next three weeks (also in hours) for each type of operation are presented in the template below.

The profit per a standard bag is $10.00 and for each deluxe bag is $9.00.

Develop a model to determine the number of standard bags and the number of deluxe bags to produce in order to maximize total profit with the condition that number of standard bags produced should be at least twice as much as number of deluxe bags produced.

Production Time (Hours)

Operation Standard Deluxe

Cutting and Dyeing 0.700 1.000

Sewing 0.500 0.833

Finishing 1.000 0.667

Inspection and Packaging 0.100 0.250

Profit Per Bag $10.00 $9.00

Model

Standard Deluxe

Bags Produced 540.0 252.0

Operation Hours Used Hours Available

Cutting and Dyeing 630.00 <= 630

Sewing 480.00 <= 600

Finishing 708.00 <= 708

Inspection and Packaging 117.00 <= 135

Total Profit 7668.00

FS2

Problem 2. Wheat is harvested at farms in Ne

aska and Colorado before being shipped to the three grain elevators in Kansas City, Omaha, and Des Moines. The amount of wheat harvested at each farm is 320 tons. The wheat is then shipped from grain elevators to the mills in Chicago, St. Louis, and Cincinnati. Each mill demands the following number of tons of wheat:

Chicago - 200, St. Louis - 100, and Cincinnati - 300. The unit shipping cost (i.e., cost per ton) between points are given in the table below. The maximum capacities of the three grain elevators are: Kansas City - 160, Omaha - 185, Des Moines - 285.

Create a model to determine the best shipment plan, which meets all requirements and minimizes the total shipment cost.

Chicago St. Louis Cincinnati Supply

Kansas City 6 8 10 150

Omaha 7 11 11 175

Des Moines 4 5 12 275

Demand 200 100 300

Chicago St. Louis Cincinnati Supply Capacity

Kansas City 0 0 150 150 150

Omaha 25 0 150 175 175

Des Moines 175 100 0 275 275

Demand 200 100 300

Requirements 200 100 300

Total 4525

FS3

Problem 3. Probability and Probability Distributions

a)The figure shows a box with 8 letters. Some letters are repeated. Suppose 4 letters are drawn at random from the box one-by-one without replacement.

What is the probability of the outcome HULU, with the letters chosen in exactly the order given? b) The statistical analysis of the long-distance calls made from the headquarters of the Bricks and Clicks Computer Corporation indicates that the length of calls is normally distributed with µ = 228 seconds and σ = 37 seconds. What is the probability that a randomly selected call lasts:

a) more than 205 seconds?

b) no more than 184 second?

c) exactly 192 seconds?

d) between 183 and...

SOLUTION.PDF## Answer To This Question Is Available To Download

- Sheet2 IDCase statusAgeSexHospitalizedDiarrheaCrampsHeadacheVomitingNauseaFeverBlood in stoolSore throatDiarrhea onset dateDiarrhea onset timeStool sampleLab resultCase definition...SolvedMar 19, 2022
- Hi! I have 3 problems relating to operations management (using statistical methods) to be solved. There does not have to be any extensive writing, just enough to answer each question with data/numbers...SolvedMar 15, 2022
- RAPP1007 Lab Test 1 Practice The data for the test is in the MS-Excel file posted with this test. You are free to use whichever method (e.g., SPSS, MS-Excel) you prefer to complete the calculations....SolvedMar 14, 2022
- Univariate Distribution Test Problems Variance Template 1 2 3 ixif(xi) xif(xi) xif(xi) xif(xi) 919130.01 30.01 40.02 20.11 928260.12 60.12 50.24 30.13 937370.24 70.24 60.1...SolvedMar 14, 2022
- Motivation The first step in the statistical process involves asking a research question. Some questions can be answered with a statistical method from Math 361, others require a more advanced...SolvedMar 14, 2022
- MAT2572 Probability and Mathematical Statistics I Assignment 1 The assignment needs be submitted in a single pdf file. Please show steps/reasoning. 1. A graduating engineer has signed up for three job...SolvedMar 11, 2022
- Problem 6.1 Problem 6.1 Consider the alloy data set, on the effect of alloy type and casting on the tensile strength of metal bars (see the documentation file for details). Fit the appropriate ANOVA...SolvedMar 09, 2022
- Running head: DATA ANALYSIS AND APPLICATION TEMPLATE 1 PAGE 2 Data Analysis and Application Template Nathalie Ocasio Capella University Data Analysis and Application (DAA) Template Use this file for...SolvedMar 09, 2022
- The purpose of this project is to determine the "statistical significance" of a difference observed in a sample. Statistical significance can aid one in making a conclusion from a data analysis by...SolvedMar 08, 2022
- Running head: DATA ANALYSIS AND APPLICATION TEMPLATE 1 PAGE 2 Data Analysis and Application Template Nathalie Ocasio Capella University Data Analysis and Application (DAA) Template Use this file for...SolvedMar 07, 2022

Copy and Paste Your Assignment Here

Disclaimer: The reference papers provided by TAE serve as model papers for students and are not to be submitted as it is. These papers are intended to be used for research and reference purposes only.

Copyright © 2022. All rights reserved.