A furniture company has opened a small plant that builds tables. Jill, the production manager, knows...

A furniture company has opened a small plant that builds tables. Jill, the production manager, knows the fixed cost of the plant, F = $78 per day, and includes the cost of the building, tools, and equipment. Variable costs include labor, energy costs, and wood. Jill wants to know the cost function. She conducts an experiment in which she varies the daily production level over a 10-day period and observes the associated daily cost. The daily output levels assigned are 1, 2, 4, 5, 7, 8, 10, 12, 15, and 16. The associated total costs for these output levels are 125, 161, 181, 202, 207, 222, 230, 275, 390, and 535, respectively.

a. Use the Trendline tool in Excel to estimate a cost function by regressing cost on output. Try a linear specification (C = a + bq), a quadratic specification (C = a + bq + dq2), and a cubic specification (C = a + bq + dq2 + eq3). Based on the plotted regressions, which specification would you recommend that Jill use? Would it make sense to use the Set Intercept option? If so, what value would you choose? (Hint: Put output in column A and cost in column B. To obtain quadratic and cubic cost specifications, select the olynomial option from the Trendline menu and set Order at 2 for the quadratic specification and at 3 for the cubic function.)

Expert Solution

Rahul Sunny answered 1 year ago

A manager at a furniture production plant created an incentive plan for her carpenters in order...

A manager at a furniture production plant created an incentive plan for her carpenters in order to decrease the number of defects in the furniture production. She wants to check if the incentive plan worked. The manager selected 9 carpenters at random, recorded their annual defects before and after the incentive and came up with the following: Salesperson Before After Adrian Gilbert 29 17 Nikki Edwards 33 23 Abigail Gage 38 19 Marc Phillips 25 15 Orla Dille 26 32...

Flair Furniture Company produces inexpensive tables and chairs. The production process for each is similar in...

Flair Furniture Company produces inexpensive tables and chairs. The production process for each is similar in that both require a certain number of labor hours in the carpentry department and a certain number of labor hours in the painting department. Each table takes 3 hours of carpentry work, an hour and a half of assembly and 2 hours of finishing work. Each chair requires 4 hours of carpentry, and hour and 15 minutes of assembly and 1 hour of painting....

A coffee roaster in Richardson has opened a retail store adjacent to the production plant. The...

A coffee roaster in Richardson has opened a retail store adjacent to the production plant. The plant manager wishes to optimize the inventory costs of the company’s best-selling coffee. The annual demand for the coffee is 36,000 bags and the plant works 240 days per yr. The plant can roast the coffee at a rate of 300 bags per day. The cost to prepare the equipment to start a production run is $350 and the annual inventory carrying cost is...

QU# 1 Kaizen Furniture has the following information in respect to coffee tables for 2011: Production...

QU# 1 Kaizen Furniture has the following information in respect to coffee tables for 2011: Production specifications: Beginning Target Ending Inventory Inventory Direct Materials: Particle board 20,000 b.f. 18,000 b.f. Red oak 25,000 b.f. 22,000 b.f. Finished goods Coffee tables 5,000 units 3,000 units Revenue expected for 2011 are: Selling price $392 per table Units sold 52,000 coffee tables Each coffee table requires 9.00 b.f. of particle board and 10.00 b.f. of...

A furniture company produces tables (X) and chairs (Y). Available resources have indicated that the production...

A furniture company produces tables (X) and chairs (Y). Available resources have indicated that the production volume level should not exceed 1200 units per week and the demand for chairs is at most half of that for tables. Further, the production level of tables can exceed three times the production of chairs by at most 600 units. If the company makes a profit of OMR12 and OMR 16 per unit respectively on tables and chairs, how many of each should...

A new electric saw for cutting small pieces of lumber in a furniture manufacturing plant has...

A new electric saw for cutting small pieces of lumber in a furniture manufacturing plant has a cost basis of $6,000 and a 10-year depreciable life. The estimated SV of the saw is zero at the end of 10 years. Use the DB method to calculate the annual depreciation amounts when: (a) R = 2/N (200% DB method) (b) R = 1.5/N (150% DB method)

A new electronic saw for cutting small pieces of lumber in a furniture manufacturing plant has...

A new electronic saw for cutting small pieces of lumber in a furniture manufacturing plant has a cost basis of $4,000 and a 10-year depreciable life. The estimated SV of the saw is zero at the end of 10 years. Calculate the book value for year six using Sinking Fund method where i = 7%.

A Furniture Company produces chairs and tables from two resources- labor and wood. The company has...

A Furniture Company produces chairs and tables from two resources- labor and wood. The company has 125 hours of labor and 45 board-ft. of wood available each day. Demand for chairs is limited to 5 per day. Each chair requires 7 hours of labor and 3.5 board-ft. of wood, whereas a table requires 14 hours of labor and 7 board-ft. of wood. The profit derived from each chair is $325 and from each table, $120. The company wants to determine...

You are the production manager for a part manufacturing company. There are 2 manufacturing locations, plant...

You are the production manager for a part manufacturing company. There are 2 manufacturing locations, plant A and B. you suspect there is a difference in the proportion of rejected parts that are manufactured at Plant A as compared to plant B. for a week you observed: Plant A Plant B total Rejected parts 120 80 200 Acceptable parts 1880 1920 3800 2000 2000 4000 The proportion of rejected parts was 200/4000=5%. If there were no difference between the proportion...

Utease Corporation has many production plants across the midwestern United States. A newly opened plant, the...

Utease Corporation has many production plants across the midwestern United States. A newly opened plant, the Bellingham plant, produces and sells one product. The plant is treated, for responsibility accounting purposes, as a profit center. The unit standard costs for a production unit, with overhead applied based on direct labor hours, are as follows. Manufacturing costs (per unit based on expected activity of 23,000 units or 57,500 direct labor hours): Direct materials (3.0 pounds at $20) $ 60.00 Direct labor...

Question