Purchase Solution

Forecasting revenue and costs

Not what you're looking for?

Ask Custom Question

With the help of your chief financial officer (CFO), you have put together the following preliminary budget figures based on last year's numbers for a planned production and sales level of 4,000 units per month:

Building depreciation $200,000/yr.
Machine operators $100,000/yr.
Management staff $400,000/yr.
Direct materials $4,000,000/yr.
Other expenses that seem to vary based on production levels $3,000,000/yr.
Other expenses that don't seem to vary $1,300,000/yr.
Selling price per unit $5,000/unit

Utilities:
This category is difficult to analyze; a part of it is related to the building's heat and light, whereas a part of it is used in the manufacturing process itself. You have the following data to which you will apply the high-low method:
? When there is no production, utility costs are $20,000/month.
? When production levels reached 4,000 units/month, utility costs totaled $40,000/month.

You are planning for the future and working on a report based on data from last year's actual performance. You are going to use the breakeven formula to determine the business's breakeven point and to answer some important questions regarding your data.

Using only the data from last year's actual performance, write a report answering the following questions:
? Which of these 8 cost categories would be considered variable, and why?
? Which of these 8 cost categories would be considered fixed, and why?
? Which costs would be considered mixed (i.e., semivariable or semifixed)?
? Ignoring utility costs altogether, what is the contribution margin per unit, in dollars and in percentage?
? Ignoring utility costs altogether, what is the breakeven level of sales?
? Ignoring utility costs altogether, if instead of breaking even, the firm wants to make $10,000/month profit, answer the following:
o How many units must be sold each month?
o To how many sales dollars is this unit volume equivalent?
? In year 2, the chief executive officer (CEO) plans to add $300,000/year of expense in added administrative salaried head count. Ignoring utility costs altogether, how many additional units must be sold just to pay for this added expense?
? Utilities: How many dollars of the utility bill are fixed? What is the variable cost per unit of utilities?
Show calculations

Purchase this Solution
Solution Summary

The solution explains how to forecast revenue and costs taking into consideration the cost behavior

Purchase this Solution
Free BrainMass Quizzes
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.

Motivation

This tests some key elements of major motivation theories.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Learning Lean

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

View More Free Quizzes
Related BrainMass Solutions

  • RevPAR and Forecasting

    Forecasting estimates the sales that will take places and to it is related costs and capacity required. It is important to forecast demand so that the firm may be prepared for the level of sales.

  • Break Even Analyses

    Companies with higher variable costs have more difficulty in planning, budgeting and forecasting their bottom line. In companies where there is an overall higher variable cost associated with revenue, there is usually....

  • Forecasting

    45343 Estimating revenues and costs Once you have the revenue and cost data, you can determine the MR and the MC. How would you estimate the revenue and cost data? Use historical information? The various ways of estimating current revenue: 1.

  • Forecasting Risk and Cost-Cutting Proposal

    307686 Forecasting Risk and Cost-Cutting Proposal Forecasting Risk - What is forecasting risk? in general, would the degree of forecasting risk be greater for a new product or a cost-cutting proposal? Why? 2.

  • XYZ Corp: Fixed Costs vs. Variable Costs scenarios

    your fixed costs to be higher and your variable costs?

  • Budget Forecasting and Reasonable Numbers

    We need to have historical data regarding revenue, costs, etc so that we can conduct a trend analysis to estimate future sales and costs.

  • Developing a Forecasting Model

    445263 Developing a Forecasting Model A regional hospital is considering the expansion of the ER to accommodate an expected increase in patient loads. Fixed (up-front) costs are equally likely to be any value between 1 and 1.5 million $.

  • approaches to revenue forecasting.

    452093 Public Budgeting: Compare and contrast qualitative, time series, and causal analysis approaches to revenue forecasting. Compare and contrast qualitative, time series, and causal analysis approaches to revenue forecasting.

  • Four forecasting variables in changing business conditions

    What are four variables used in the forecasting portion of the budgeting process? 1. Revenue (Sales) 2. Overhead Expenses 3. Cost of Goods Sold 4. Interest and Depreciation What is the danger of forecasting based on history alone?

  • Outpatient APC Reimbursement

    The expert examines the changes mess up for a revenue budgeting or forecasting.

View More Related Solutions