Question

In: Accounting

TJ’s Cheese Cake Factory, Inc. sells original cheese cake for $16 each. The company provided the...

TJ’s Cheese Cake Factory, Inc. sells original cheese cake for $16 each. The company provided the following units and total cost data concerning its cake sales for each month during 2011:

Cost Units
January 55000 2500
February 59000 2800
March 60000 3000
April 64000 4200
May 67000 4500
June 71000 5500
July 74000 6500
August 77000 7500
September 75000 7000
October 68000 4500
November 62000 3100
December 73000 6500

a. Use the linear regression method to estimate fixed and variable costs. Excel has a function that you can use (I have posted these data in excel on Blackboard for your convenience). Print out the regression output and attach to this test.

b. Interpret and evaluate your regression model and results. Write out the cost formula.

c. Estimate total costs in a month when 6,000 cakes are produced and sold.

d. Estimate total profit in a month when 6,000 cakes are produced and sold.

e. You are working on the budget for October 2012 and expect 10,000 cakes will be produced and sold. Estimate total costs in a month when 10,000 cakes are produced and sold. Will you use the estimated cost in your budget? Why?

f. How does linear regression differ from the high-low method in estimating fixed and variable costs? Discuss the pros and cons of each.

Solutions

Expert Solution

e) Linear regression is great when the relationship to between covariates and response variable is known to be linear (duh). This is good as it shifts focus from statistical modeling and to data analysis and preprocessing. It is great for learning to play with data without worrying about the intricate details of the model.

A clear disadvantage is that Linear Regression over simplifies many real world problems. More often than not, covariates and response variables don’t exhibit a linear relationship. Hence fitting a regression line using OLS will give us a line with a high train RSS.

In summary, Linear Regression is great for learning about the data analysis process. However, it isn’t recommended for most practical applications because it oversimplifies real world problems.

So, I will not use the estimated cost in my budget.

f) The high low method uses a small amount of data to separate fixed and variable costs. It takes the highest and lowest activity levels and compares their total costs. On the other hand, linear regression shows the relationship between two or more variables. It is used to observe changes in the dependent variable with changes in the independent variable.

Pros of high-low method:

1)Easy to use

The high-low method only requires the cost and unit information at the highest and lowest activity level to get the required information. Managers can implement this technique with ease since it does not require any special tools.

2)High accuracy with stable costs

The high low method can be relatively accurate if the highest and lowest activity levels are representative of the overall cost behavior of the company. However, if the two extreme activity levels are systematically different, then the high-low method will produce inaccurate results.

Cons of high-low method:

1)Unreliable

The method does not represent of all the data provided since it relies on just two extreme activity levels. The activity levels may not be representative of the costs incurred due to outlier costs that are higher or lower than what the organization incurs in the other activity levels.

2)Does not account for inflation

The high-low method excludes the effects of inflation when estimating costs.

Pros of linear regression:

1) Space complexity is very low it just needs to save the weights at the end of training. hence it's a high latency algorithm.

2) Its very simple to understand

3) Good interpretability

4) Feature importance is generated at the time model building. With the help of hyperparameter lamba, you can handle features selection hence we can achieve dimensionality reduction

Cons of linear regression:

1) The algorithm assumes data is normally distributed in real they are not.

2) Before building model multicollinearity should be avoided.

3) prone to outliers


Related Solutions

Robinson Pizza Company agreed to buy 25 pounds of mozzarella cheese from the Clemens Cheese Factory...
Robinson Pizza Company agreed to buy 25 pounds of mozzarella cheese from the Clemens Cheese Factory for $5 per pound. When the cheese was delivered, Robinson discovered that one 10 pound block of cheese was a bit moldy and, he believed, unusable. Clemens sent Robinson a bill for $125 and demanded payment. Robinson called up Clemens and refused to pay that much but indicated that he was willing to pay $75. Clemens said “Not enough. Give me $80 and I...
This is the same information as the previous question. Martinez Cake Company sells birthday cakes and...
This is the same information as the previous question. Martinez Cake Company sells birthday cakes and fruit cakes in bulk through its Internet business. Estimated overhead costs for the coming year total $330,000. The accountant for Martinez identified the following information in preparation for an activity-based costing system. Activity Allocation Base Overhead Cost Purchasing Number of purchase orders $82,500 Processing Number of units processed $198,000 Sales Number of sales orders $49,500 The estimated activity level for each type of cake...
Cheeseburger and Taco Company purchases 17,886 boxes of cheese each year.
Cheeseburger and Taco Company purchases 17,886 boxes of cheese each year. It costs $20 to place and ship each order and $6.76 per year for each box held as inventory. The company is using Economic Order Quantity model in placing the orders.
Ergonomics, Inc. sells ergonomically designed office chairs. The company provided the following information: Average Demand =...
Ergonomics, Inc. sells ergonomically designed office chairs. The company provided the following information: Average Demand = 15 units per day Average lead time = 20 days Item unit cost = $60 for orders of less than 200 units Item unit cost = $58 for orders of more 200 units or more Ordering costs = $30 Inventory carrying costs = 25% The business year is 250 days Based on the above information: How many chairs should the firm order each time?...
Decaprio Inc. produces and sells a single product. The company has provided its contribution format income...
Decaprio Inc. produces and sells a single product. The company has provided its contribution format income statement for June. Sales (5,500 units) $ 192,500 Variable expenses 82,500 Contribution margin 110,000 Fixed expenses 86,500 Net operating income $ 23,500 If the company sells 5,700 units, its net operating income should be closest to: (Do not round intermediate calculations.)
Knitline Inc. produces high-end sweaters and jackets in a single factory. The following information was provided...
Knitline Inc. produces high-end sweaters and jackets in a single factory. The following information was provided for the coming year. Sweaters Jackets Sales $ 209,600 $ 449,000 Variable cost of goods sold 145,500 196,600 Direct fixed overhead 25,400 47,800 A sales commission of 6% of sales is paid for each of the two product lines. Direct fixed selling and administrative expense was estimated to be $19,900 for the sweater line and $50,400 for the jacket line. Common fixed overhead for...
Boards Inc. fabricates skateboards that the company sells for $ 37.50 each. Fixed costs for the...
Boards Inc. fabricates skateboards that the company sells for $ 37.50 each. Fixed costs for the last 12 months equaled $4,800. For the same period variable cost per unit equaled $22.50. Use the unit variable cost and sales price to calculate the unit contribution margin: 9120 Calculate the breakeven sales volume. BLANK-2 Calculate the sales volume necessary to produce a target Net Income of $3,000 per month. BLANK-3 The skateboards are manufactured in an old factory that relies heavily on...
Martinez Cake Company sells birthday cakes and fruit cakes in bulk through its Internet business. Estimated...
Martinez Cake Company sells birthday cakes and fruit cakes in bulk through its Internet business. Estimated overhead costs for the coming year total $330,000. The accountant for Martinez identified the following information in preparation for an activity-based costing system. Activity Allocation Base Overhead Cost Purchasing Number of purchase orders $82,500 Processing Number of units processed $198,000 Sales Number of sales orders $49,500 The estimated activity level for each type of cake and in total is as follows: Birthday Cakes Fruit...
Phoenix Company can invest in each of three cheese-making projects: C1, C2, and C3. Each project...
Phoenix Company can invest in each of three cheese-making projects: C1, C2, and C3. Each project requires an initial investment of $282,000 and would yield the following annual cash flows. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) C1 C2 C3 Year 1 $ 30,000 $ 114,000 $ 198,000 Year 2 126,000 114,000 78,000 Year 3 186,000 114,000 66,000 Totals $ 342,000 $ 342,000 $ 342,000 (1) Assume...
The Pleading Painters’ Group sells artwork at wholesale prices to office building decorators. Each original painting...
The Pleading Painters’ Group sells artwork at wholesale prices to office building decorators. Each original painting is delivered in a wooden frame. There are two kinds of frames: the basic frame requires 15 minutes to precut, 10 minutes to assemble, and 5 minutes to paint. It uses 8 board feet and costs $8 to make. The deluxe frame takes 20 minutes to precut, 10 minutes to assemble, and 15 minutes to paint. It requires 12 board feet and costs $16...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT