Question
Eric and Heather agree that there also is a need for better forecasting regarding the companys cash inflows and outflows. After a series of questions,
Eric and Heather agree that there also is a need for better forecasting regarding the companys cash inflows and outflows. After a series of questions, you determined that (1) the company had not prepared a cash budget for several quarters and (2) is not up to date on its payables and receivables. You are going to prepare a forecasted income statement and a forecasted cash budget for the fourth quarter. Pertinent information needed has been collected and is outlined below. Pertinent Information: The business manager/accountant and Heather provided projections for the 1st quarter 2021 (January through March 2021) and other information outlined below:
- Total sales 4th quarter 2020: 58,500 10-oz bottles; Sales price is $8/bottle
- Total Sales for the 1st quarter 2021 are projected to increase 5% above the 4th quarter 2020 total sales due to an aggressive marketing program that began December 1, 2020. Total quarter sales per month are expected to be realized as follows: 40% in January, 35% in February, and 25% in March. The sales budgets expressed in sales dollars and in the number the number of bottles sold are as follows
PROJECTED
Oct
Nov
Dec
TOTAL QTR
SALES REVENUE
SALES
$126,945
$177,723
$203,112
$507,780
SALES: PRICE X QUANTITY
$126,945
$177,723
$203,112
$507,780
Number of Bottles Sold
Oct
Nov
Dec
TOTAL QTR
Number of Bottles Sold
15,356
21,499
24,570
61,425
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started