Question

In: Accounting

A ​Juarez, Mexico, manufacturer of roofing supplies has developed monthly forecasts for a family of products....

A ​Juarez, Mexico, manufacturer of roofing supplies has developed monthly forecasts for a family of products. Data for the​ 6-month period January to June are presented in the table below. There are 8 hours of production per day.

​a) The firm would like to begin development of an aggregate plan. For this​ plan, plan​ 5, the firm wishes to maintain a constant workforce of 6​, using subcontracting to meet remaining demand. Evaluate this plan.

To determine whether this plan is​ desirable, first calculate demand per day for each month ​(enter your responses rounded to the nearest whole​ number).

Table 1

Month

Production Days

Demand Forecast

Avg Dem Per Prod. Day

1

January

22

950

_______

2

February

18

750

________

3

March

21

750

_______

4

April

21

1,000

_______

5

May

22

1,300

_______

6

June

20

1,050

_______

Other data

Inventory carrying cost

​$8

per unit per month

Subcontracting cost per unit

​$12

per unit

Average pay rate

​$5

per hour

​($40

per​ day)

Overtime pay Rate

​$7

per hour​ (above 8 hrs per​ day)

​Labor-hours per unit

1.6

hrs per unit

Cost of increasing daily production rate​ (hiring &​ training)

​$300

per unit

Cost of decreasing daily production rate​ (layoffs)

​$600

per unit

The production rate per day = _____ units. ​(Enter your response as a whole​ number.)

Fill in the table below. ​(Enter your responses as whole​ numbers.)

                                                                                           

Month

Demand

Regular Production

Subcontract

​(Units)

1

January

950

_______

______

2

February

750

________

______

3

March

750

________

______

4

April

1,000

_______

_______

5

May

1,300

______

_______

6

June

1,050

______

_______

The total regular production cost=​ $ ______ ​(Enter your response as a whole​ number.)

The total subcontracting cost =​ $ ______ (Enter your response as a whole​ number.)

Total cost with plan 5​ = ​$ ______ (Enter your response as a whole​ number.)

​b) Juarez has yet a sixth plan. A constant workforce of 7 is​ selected, with the remainder of demand filled by subcontracting. Evaluate this plan.The production rate per day = ______ units. ​(Enter your response as a whole​ number.)

Fill in the table below. ​(Enter your responses as whole​ numbers.)

Month

Demand

Regular Production

Subcontract​ (Units)

1

January

950

_________

________

2

February

750

_________

________

3

March

750

_________

________

4

April

1,000

_________

__________

5

May

1,300

__________

_________

6

June

1,050

__________

_________

The total regular production cost =​ $ ______ ​(Enter your response as a whole​ number.)

The total subcontracting cost =​ $ _______ (Enter your response as a whole​ number.)

Total cost with plan 6 =​ $ _______ ​(Enter your response as a whole​ number.)

Solutions

Expert Solution

Answer :


Related Solutions

Carolina Roof Construction sells roofing supplies and equipment. Experience has shown the owner, John Fransen, that...
Carolina Roof Construction sells roofing supplies and equipment. Experience has shown the owner, John Fransen, that the sales have a significant seasonal variability. It is critical that the sales forecasts are accurate so Fransen can plan the cash flow of the business. The file Carolina Roof Construction Spring 2019 contains the sales figures for 2011 to 2018.  Produce a forecast using regression of deseasonalized sales and reseasonalize the forecast. Write a report to Frans and include your forecast for winter, spring,...
Viking InterWorks is a manufacturer that supplies memory products to original equipment manufacturers of desktop systems....
Viking InterWorks is a manufacturer that supplies memory products to original equipment manufacturers of desktop systems. The CEO read that the upcoming year’s projected demand for 512 MB desktop memory modules is Qd(memory)= 20000-80p(memory) -P(desktops)+ 0.6M. Where P(memory)  is the market price for 512 MB memory module, P(desktop) is the selling price of a desktop system, and M is consumer income. Are memory modules and desktop systems complements or substitutes. Please provide a reason for your answer. (2 points). What would...
Ferrous Supplies, Inc., a manufacturer of finished steel products from recycled metals and recycled ferrous and...
Ferrous Supplies, Inc., a manufacturer of finished steel products from recycled metals and recycled ferrous and non-ferrous metal and auto parts, is evaluating two mutually exclusive investment projects. In the first project, the firm will supply 9,000 wheels annually to Ford Motor Company at an average price of $700 per wheel over a period of 7 years. The second project involves the supply of 12,500 auto exhaust systems annually to General Motors Company at an average price of $400 per...
Barrington Bears has developed the following sales forecasts for the next few months. January 500, February...
Barrington Bears has developed the following sales forecasts for the next few months. January 500, February 600, March 720, April 800 and May 770. BB has 80 bears on hand on Dec. 31. Normal ending inventory policy is to hold 20% of next month’s sales. Each bear needs .8 yards of fabric and two pounds of stuffing. Fabric is budgeted to cost $15 per yard and stuffing $4 per pound. Direct labor is paid $18 per hour. Each bear takes...
A lightbulb manufacturer has developed a new lightbulb that it claims has an average life of...
A lightbulb manufacturer has developed a new lightbulb that it claims has an average life of more than 1,000 hours. A random sample of 50 lightbulbs was taken and had a mean of 1,065 hours and standard deviation of 125 hours. Perform a hypothesis test with a level of significance of 0.01. Perform steps 2 and 3 of the hypothesis test. Perform step 4 of the hypothesis test using the information from the last question. Perform step 5 of the...
11. A family has to decide how much of their monthly income they will spend on...
11. A family has to decide how much of their monthly income they will spend on good A and how much they will spend on good B. Assume that the price of good A is $20, the price of good B is $4, and the monthly income of the family is $600. On a piece of paper, plot the budget constraint faced by this family putting the quantity of good A on the horizontal axis and the quantity of good...
A marine equipment manufacturer has developed a new hydrophone line that the company claims has a...
A marine equipment manufacturer has developed a new hydrophone line that the company claims has a mean 10 kilogram breaking force with a standard deviation of 0.5 kilograms. Check the hypothesis that μ = 8 kilograms is checked against the alternative that μ = 8 kilograms if a 50-line random sample is checked and a mean breaking force of 7.8 kilograms is observed. Using a 0.05 grade significance
Florence is considering going into business for herself and has developed the following estimates of monthly...
Florence is considering going into business for herself and has developed the following estimates of monthly costs and revenues to aid her in her decision-making process. She has decided to house the business in a building that she already owns, although she could rent the building to someone else for $1,000 per month. Estimated payments for utilities (electricity, natural gas, water, and telephone) are $475 per month. She will hire one employee at a total cost of $1,100 per month....
The founder of X company , a manufacturer of fine fishing supplies, has provided you the...
The founder of X company , a manufacturer of fine fishing supplies, has provided you the following information from his company's accounting records. From the information presented, prepare a properly formatted, multi-step Income Statement (be sure to show intermediate profit lines - Gross Profit, EBITDA, NOI, EBIT, EBT and NI - as necessary). Per share presentation of income data is not being requested. Balance sheet account information is as of the close of business for December 31, 2017 unless otherwise...
A family has a $ 113,739 25​-year mortgage at 5.4 % compounded monthly. ​(A) Find the...
A family has a $ 113,739 25​-year mortgage at 5.4 % compounded monthly. ​(A) Find the monthly payment and the total interest paid. ​(B) Suppose the family decides to add an extra​ $100 to its mortgage payment each month starting with the very first payment. How long will it take the family to pay off the​ mortgage? How much interest will the family​ save? ​(A) Monthly​ payment: ​$ nothing ​(Round to two decimal​ places.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT