Purchase Solution

Regression Analysis: Sales and Total Variable Costs

Not what you're looking for?

Ask Custom Question

Over the past 12 months the Four Winds Novelty Company firm has recorded its internet sales (equals monthly output levels) and its monthly total variable costs (TVC) for a particular novelty item as shown in the following table. Sales have grown over this period with relatively few shocks due to uncontrollable weather, political and sporting events. This online retailer carries no inventories; when it receives a pre-paid on-line order from a customer, it simply buys the product from a supplier and ships it out to the customer.
Sales = Output TVC ($)
102,813
176,163
196,121
222,885
226,356
296,416
378,446
450,666
579,696
607,082
624,680
636,133
TVC
201,953
340,608
377,940
432,863
441,714
629,267
867,596
1,103,807
1,701,125
1,917,861
2,195,352
2,479,195

a) Using regression analysis, find an equation that best fits the data to represent the TVC function. (I was able to duplicate the example in the book for the cubic equation, but not the quadratic or linear equations -- I must be doing something wrong in the excel regression analysis, but I don't know what). I also do not completely understand how to interpret the output of the analysis to determine best fit.
b) At what sales/output level will marginal costs (MC) reach a minimum?
c) Estimate the value of TVC for sales/output level 250,000 units, and calculate the 95% confidence interval for your estimate

Purchase this Solution
Solution Summary

This solution shows a regression output on sales and variable costs for Four Winds Novelty Company. The problem includes data analysis based on the monthly internet sales and total variable costs. The regression analysis has been done with the Excel Data Analysis tool, with explanations on how to interpret the output data. The solution also shows how to find the minimum level of marginal cost (MC) and to predict a 95% confidence level of sales on a particular level of variable costs using the regression equation.

Solution Preview

Dear Student:

Please open the attached Excel file and then follow the explanations below:

a)
Data in worksheet Data and regression in worksheet Regression. The attached regression was run using the Data Analysis add-in in the Data tab. (If you are using some other tool, you would have to adjust accordingly.) Choose regression, then variables and the confidence level. Then input the range of cells where the data is located. Make sure that ...

Purchase this Solution
Free BrainMass Quizzes
Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

View More Free Quizzes
Related BrainMass Solutions

  • Cost Estimation, CVP analysis

    Data on the company's total costs and output for the past six months appear in the table that follows. The result of the regression analysis are also provided. a. Plot the data and regression line on a graph. b.

  • Cost Function Estimates for Bookkeeping Franchise Opportunity

    Profit equation and contribution margin Profit = Total revenue - Total costs but total cost = total variable cost + total fixed cost therefore profit = total revenue - Total variable cost - total fixed cost Contribution margin = total revenue

  • Academic approach to Case study

    We want to predict total costs, and we know the number of units produced. Do a simple linear regression to predict the total costs. What is your dependent variable? What is your independent variable?

  • MCQs on regression, budgeting, Accounting

    Total cost * The following excerpts from four regression analysis reports describe the relationship between a major operating cost and four cost drivers for Tory Corp: ---------------------------------------------------------------------

  • One of its costs is a mixed cost and has run a regression analysis

    The expert examines one of its costs is a mixed cost and has run a regression analysis.

  • cost accounting practice exam

    Using the regression analysis determine the variable cost per unit, the total fixed cost, and express in a formula.

  • Accounting: Costs and Income Statements

    (c) The least squares regression method is generally considered to be the most accurate method of cost analysis. ________________________________________ Exercise 5-1 Fixed and Variable Cost Behavior [LO1] Koffee Express operates a number of

  • Regression Analysis and Control Chart Analysis

    Also, regression analysis is used to create a total cost function and to determine the total cost based on changing the x variable, fixed cost and variable cost.

  • Total fixed cost per month produced

    Using the least-squares regression method, estimate the variable cost per function and the total fixed cost per month. (Round off the variable cost per function to the nearest cent and the total fixed cost to the nearest dollar.) C.)

View More Related Solutions