Purchase Solution

Cost estimation

Not what you're looking for?

Ask Custom Question

SomethingNew is a small one-person company that provides elaborate and imaginative wedding cakes to order for very large wedding receptions. The owner of the company would like to understand the cost structure of the company and has compiled the following records of activity and costs incurred. The owner believes that the number of weddings catered is the best measure of activity.

Month
Weddings
Costs Incurred

January
3
$3,800

February
2
$3,600

March
6
$4,000

April
9
$4,300

May
12
$4,500

June
20
$5,200

Required:

a. Using the high-low method, estimate the variable cost per wedding and the total fixed cost per month. (Round off the variable cost per wedding to the nearest cent and the total fixed cost to the nearest dollar.)

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

c. What would be the estimated costs if the company anticipates catering 18 weddings in July?

Purchase this Solution

Solution Summary

Excel file shows cost estimation using high-low method and the least-squares regression method.

Purchase this Solution


Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Operations Management

This quiz tests a student's knowledge about Operations Management

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.