Question

In: Finance

The sales forecast is based on projected levels of demand. All the numbers are expressed in...

The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars.

Price per bus $220,000

Units sold per year 12,250

Labor cost per bus $32,500

Components & Parts $86,500

Selling General & Administrative $200,000,000

The average warranty cost per year per bus for the first five years is $2,000. The present value of this cost will be used as a cost figure for each bus. Afterwards, the bus operator will become responsible the repairs on the buses. The buses can be produced for 15 years. Afterwards, the designs become obsolete.

Solutions

Expert Solution

As per given case

Price per bus $220,000

Units sold per year 12,250

Labor cost per bus $32,500

Components & Parts $86,500

Selling General & Administrative $200,000,000

Lets calculate sales Forcast for each Bus basis

Selling Price per Bus = $ 220,000

Cost of production

              Labor Cost per Bus $ 32500

          + Component & parts $ 86500

       + Seelling General Admin $16326.53 (Derived from $200,000,000/No. of Unit 12250)

      + Average warranty cost $ 2000 x 5 Years =$ 10000

________________________________________________________

Total Cost of Production = $ 1,45,326.50

____________________________________________

Total Profit per Bus = $ 74673.47

_________________________________

Total Profit with sale = $ 74673.47 x 12250 = $9,14,750,008

Total Sales = $2,695,000,000


Related Solutions

Exhibit 1:   Sales and Cost Forecast The sales forecast is based on projected levels of demand....
Exhibit 1:   Sales and Cost Forecast The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. The forecasted average inflation per year is 3.0% . Price per bus $220,000 Units sold per year 11,000 Labor cost per bus $50,000 Components & Parts per bus $95,000 Selling General & Administrative (fixed) $250,000,000 NOTE: Average warranty cost per year per bus for the first five years is $1,000. The present value of this cost...
Exhibit 1:   Sales and Cost Forecast The sales forecast is based on projected levels of demand....
Exhibit 1:   Sales and Cost Forecast The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. The forecasted average inflation per year is 3.0% Price per bus $220,000 Units sold per year 11,000 Labor cost per bus $50,000 Components & Parts per bus $95,000 Selling General & Administrative (fixed) $250,000,000 NOTE: Average warranty cost per year per bus for the first five years is $1,000. The present value of this cost will...
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the...
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. ACTUAL June 142 July 182 August 121 Using single exponential smoothing and assuming that the forecast for June had been 120, forecast sales for September with a smoothing constant α of 0.30. (Do not round intermediate calculations. Round your answer to...
Analyze the Sales Budget your team has created. Based on the projected revenue numbers within the...
Analyze the Sales Budget your team has created. Based on the projected revenue numbers within the quarterly data given, determine approximately how many new airplanes will be needed to generate the necessary revenue on an annualized basis. The industry uses Passenger Seat Miles as a measure of revenue. Current data fm the industry shows revenue per Passenger Seat Mile is 16 cents. ExpressJet believes that their revenue will go up by one cent per month during the quarter. An average...
A manager receives a forecast for next year. Demand is projected to be 528 units for...
A manager receives a forecast for next year. Demand is projected to be 528 units for the first half of the year and 960 units for the second half. The monthly holding cost is $2 per unit, and it costs an estimated $55 to process an order. a. Assuming that monthly demand will be level during each of the six-month periods covered by the forecast (e.g., 88 per month for each of the first six months), determine an order size...
The business analyst for Video Sales, Inc. wants to forecast yearly demand for DVD decoders based...
The business analyst for Video Sales, Inc. wants to forecast yearly demand for DVD decoders based on the following historical data:YearDemand5 years ago9004 years ago7003 years ago6002 years ago500Last year300What is the forecast for this year using a three-year simple moving average? What is the forecast for last year using simple exponential smoothing with smoothing constant alpha = 0.4, if the forecast for two years ago was 750? What is the forecast for this year using simple exponential smoothing with smoothing constant...
Sales Forecast Almost all financial plans require an externally supplied sales forecast. In our models that...
Sales Forecast Almost all financial plans require an externally supplied sales forecast. In our models that follow, for example, the sales forecast will be the “driver,” meaning that the user of the planning model will supply this value, and most other values will be calculated based on it. This arrangement is common for many types of business; planning will focus on projected future sales and the assets and financing needed to support those sales. Frequently, the sales forecast will be...
Given the following demand numbers, create a forecast for April through January of the following year....
Given the following demand numbers, create a forecast for April through January of the following year. The forecast demand for a time period is the average of the previous three time periods. This is called a three-period moving average. For example, the April Forecast of 101 is the average of the Demand for January through March. The following table contains the demand numbers and the forecast. Use Excel to calculate the values in the Forecast column. A spreadsheet without formulas...
Sales forecast based on external data.  Raspberry Phones uses external data to forecast the coming​ year's...
Sales forecast based on external data.  Raspberry Phones uses external data to forecast the coming​ year's sales. The company has 7.5 % of all​ new-phone sales in the United States and 5.6 % of all​ replacement-phone sales. Industry forecasts predict 18.9 million​ new-phone buyers and 31.8 million​ replacement-phone buyers in 2014. If the average Raspberry phone costs ​$84.05​, what sales revenues is the company forecasting for​ 2014?
Forecast the balance sheet for Lambert Co. using the following projected information ($000). Round all projections...
Forecast the balance sheet for Lambert Co. using the following projected information ($000). Round all projections to the nearest thousand dollars. Sales $10000 Cash $500 Accruals $50 Gross Margin 45% Inventory Turns (based on COGS) 7.0 Total Asset Turnover 1.25 Current Ratio 2.0 Debt: Equity 1:3 ACP 42 days Assets Liabilities Cash ? A/P ? A/R ? Accruals ? Inventory ? C/L ? C/A ? Debt ? Net F/A ? Equity ? Total Assets ? Total L&E ?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT