Question
This is an assignment that the class has due, I am a about to become the class tutor and I am completely stumped on how
This is an assignment that the class has due, I am a about to become the class tutor and I am completely stumped on how to get the answer. Is the answer on this site?
Your company has recorded the following sales figures for last year:
- January$30,000
- February$35,000
- March$31,000
- April$32,000
- May$34,000
- June$35,000
- July$36,000
- August$35,000
- September$34,000
- October$32,000
- November$30,000
- December$32,000
You have decided to select a five-month weighted, moving average (you believe that the weights should be 1, 2, 2, 3 and 4) for forecasting next year's monthly sales with 4 being the weight for the most recently completed month.
Based on last year's data:
Cash sales are 30% of total sales for each month.
Of the remaining 70% which are credit sales (Accounts Receivable):
75% are collected in the month after the sale and
25% are collected in the second month following the sale.
The Forecast for expenses next year is based on monthly expenses from last year in which the costs averages were:
- cost of goods sold was 50% of sales and paid in the same month of the sales
- rent, $1,500
- utilities, $400
- insurance, $1,000
- payroll $6,000
- interest, $500
For next year's forecast:
- Your rental agreement provides for a 5% increase in the coming year.
- Utility costs in your area will increase by 10% next year.
- You just received a notice from your insurance company stating your monthly premium is increasing by $600 beginning the first month of next year.
- Your payroll is expected to increase 5%
- Interest expense is expected to remain the same.
1)Construct a table that shows the sales forecasts for January, February and March of next year. (Note your moving average forecasts for February & March will use both actual sales from last year and forecast sales for the new year).
2)Using the format from the pro forma cash budget in Chapter 6, what is your monthly cash budget for January, February and March?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started