Question

In: Accounting

Period Forecast 1 200 2 500 3 300 4 400 5 200 6 200 Regular time:...

Period Forecast
1 200
2 500
3 300
4 400
5 200
6 200

Regular time: $20 per unit (maximum of 280 units per period)

Overtime:    $30 per unit (maximum of 40 units per period)

Subcontracting:    Not available

Beginning inventory:   None

Carrying cost: $10 per unit per period

Backorder cost: $50 per unit per period

What is the total regular time cost for the plan which minimizes total cost?

Round answer to nearest dollar. Do not use a thousands separator or a dollar sign in your answer.

Solutions

Expert Solution

Period Forecast Regular time production Overtime production Backorder fulfillment
1 200 280 40 0
2 500 280 40 60
3 300 280 40 0
4 400 280 40 60
5 200 200 0 0
6 200 200 0 0
TOTAL 1800 1520 160 120

Total number of regular time production = 1520

Cst per unit of production in regular time = 20

Total cost of production in regular time = 1520 * 20 = 30400

How much to produce in each month and fulfill through backordering can be decided on the basis of the following criteria:

1.) Producer will want to produce as much as possible in regular time as much possible to fulfill requirements of current month as well as month to avoid backorder costs as much as possible.

2.) Current month regular time production cost to fulfill requirements of coming month is equal to overtime cost of production per unit in coming month and less than backorder cost per unit in coming month but both regular time production units and overtime production units is limited so in case of high demand without backordering demand can not be fulfilled.

3.) Current month overtime production cost per unit to fulfill requirements of coming month is less than backorder cost per unit in coming month.


Related Solutions

Time 0 1 2 3 4 5 Cash flows -800 80 100 300 500 500 Financing...
Time 0 1 2 3 4 5 Cash flows -800 80 100 300 500 500 Financing rate=15% Reinvestment rate=20% a) Write the excel command to calculate the NPV: b) Write the NPV numerical value: c) Write the excel command to calculate the IRR: d) Write the IRR numerical value: e) Write the excel command to calculate the MIRR: f) Write the MIRR numerical value: h) Write the excel command to calculate the PI: i) Write the PI numerical value:
Consider the following time series: Period 1, 2, 3, 4, 5, 6, 7, 8 Demand 15,...
Consider the following time series: Period 1, 2, 3, 4, 5, 6, 7, 8 Demand 15, 17, 14, 7, 10, 12, 7, 5 A. using a trend projection, forecast the demand for period 9 b. calculate the MAD for this forecast SHOW ALL WORK! DO NOT USE EXCEL OR PHSTAT!
Time Period t Daily Sales 1 40 2 28 3 37 4 46 5 35 6...
Time Period t Daily Sales 1 40 2 28 3 37 4 46 5 35 6 33 7 52 8 49 9 50 10 28 11 44 12 30 13 69 14 58 15 61 16 58 17 46 18 59 19 48 20 64 Given the Data Above for the first 20 days Daily Sales of a new restaurant, use a Regression Tool like DATA ANALYSIS in Excel and find each of the following: Slope of Regression Equation =...
ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5...
ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5 8 7 6 5 7 7 6 7 8 8 8 9 7 8 10 12 11 Test the significance of the correlation coefficient. Then use math test scores (X) to predict physics test scores (Y).  Do the following: Create a scatterplot of X and Y. Write the regression equation and interpret the regression coefficients (i.e., intercept and slope). Predict the physics score for each....
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6 6] This is my dataset Find mean, median, mode, variance, standard deviation, coefficient of variation, range, 70th percentile, 3rdquartile of the data and skewness and define what each of these statistics measure. For example, mean is a measure of the central tendency, what about the rest? Use Chebyshev’s rule to find...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6 6] This is my dataset Split the dataset in two equal parts. You have 30 datavalues. If you split the data in two equal parts each part will contain 15 data values.  Call the first part Y and second part X.Draw scatter plot of the 2 datasets, X being on the horizontal...
tens Units 1 5 2 3 4 8 5 2 5 6 9 6 1 3...
tens Units 1 5 2 3 4 8 5 2 5 6 9 6 1 3 5 4 7 9 7 0 0 4 5 6 9 9 8 1 3 5 6 8 9 9 0 1 2 3 5 9 The table represent a random sample of 31 test scores taken from a large lecture class. Find the following [round to 2 decimal points X. XX] a) [2 pts] Find the 5 number summary [L, Q1, Q2, Q3,...
A loan L is repaid with annual payments of $500, $400,$300, and $200 at the end...
A loan L is repaid with annual payments of $500, $400,$300, and $200 at the end of each year using a sinking fund method. If the loan has 10%effective interest rate per year and the sinking fund has 8% effective interest our year, find L
Time (hours) spent on social media per day 2 5 4 6 3 2 4 1...
Time (hours) spent on social media per day 2 5 4 6 3 2 4 1 0 1 3 2 5 4 2 6 3 7 4 3 5 2 4 1 3 4 2 4 3 5 3 6 3 2 4 1. For the above data set, give the minimum and maximum score and calculate the range. 2. Calculate the standard deviation (show your work). 3. Choosing the appropriate format, draw a bar chart or histogram of the...
X 1 3 5 3 4 4 Y 2 5 4 3 4 6 A: Plot...
X 1 3 5 3 4 4 Y 2 5 4 3 4 6 A: Plot the date B: find the line of best fit C: determine ŷ AT x=3 D: Find r and r^2 E: explain r and r^2
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT