Eric and Heather agree that there also is a need for better forecasting regarding the company's...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Eric and Heather agree that there also is a need for better forecasting regarding the company's 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 1" quarter 2021 (January through March 2021) and other information outlined below: 1. Total sales 4th quarter 2020: 58,500 10-oz bottles; Sales price is $8/bottle 2. Total Sales for the 1st quarter 2021 are projected to increase 5% above the 4" 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 SALES REVENUE SALES SALES: PRICE X QUANTITY Number of Bottles Sold Number of Bottles Sold Oct a. Cash sales... b. Credit sales. $126,945 $126,945 Oct 15,356 Nov $177,723 $177,723 Nov 21,499 Dec $203,112 $203,112 Dec 24,570 TOTAL QTR 3. Monthly Sales are classified as follows and realized in corresponding percentage: 30% of total sales 70% of total sales $507,780 TOTAL QTR $507,780 61,425 4. Monthly credit sales are collected as follows and in the corresponding proportion: a. Collected in the month of the sale, 50% b. Collected one month after the sale month, 30% c. Collected the second month after the sale month, 20% 5. Cost Classifications based on 4th quarter information: Raw Materials Used in Manufacturing (See corrected COGS Schedule in Part 1, Required #1) $ Costs Direct Labor Factory Overhead: Rent-Factory Indirect Labor Insurance-Factory (66 2/3%) Utility-Factory (75%) Depreciation-factory building Advertising expense Selling & Administrative Wages and Salaries Utility-Selling & Administrative (25%) Insurance-Administrative (33 1/3%) Depreciation-Administrative PROJECTED RAW MATERIAL PURCHASES Actual Costs on 4th Quarter Income Statement 114,000 General Administrative NEEDED FOR SALES DESIRED ENDING LESS: BEGINNING PURCHASES Oct $34,503 8,626 (40,800) $2,329 Variable Costs Nov $48,304 12,076 (8,626) $51,755 ? 9. Additional monthly obligation paid in cash include: 6. All factory overhead and administrative expenses (except depreciation) are paid in cash in the month the cost is incurred. 7. Direct labor is paid at the end of the month 16,800 8. Raw material purchases are paid as follows: 50% in the month of the purchase, 30% the month after the purchase, and 20% in the second month following the purchase. The raw materials budget is as follows: a. Property taxes, due February 27, 2021: $2,790 b. Employee payroll taxes due March 15, 2021: $900. 5,400 18,000 1,680 Fixed Costs Dec $36,000 $55,205 13,801 (12,076) $56,930 3,630 1,800 18,200 64,000 67,000 720 2,970 27,000 TOTAL QTR $138,012 $111,013 Eric and Heather agree that there also is a need for better forecasting regarding the company's 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 1" quarter 2021 (January through March 2021) and other information outlined below: 1. Total sales 4th quarter 2020: 58,500 10-oz bottles; Sales price is $8/bottle 2. Total Sales for the 1st quarter 2021 are projected to increase 5% above the 4" 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 SALES REVENUE SALES SALES: PRICE X QUANTITY Number of Bottles Sold Number of Bottles Sold Oct a. Cash sales... b. Credit sales. $126,945 $126,945 Oct 15,356 Nov $177,723 $177,723 Nov 21,499 Dec $203,112 $203,112 Dec 24,570 TOTAL QTR 3. Monthly Sales are classified as follows and realized in corresponding percentage: 30% of total sales 70% of total sales $507,780 TOTAL QTR $507,780 61,425 4. Monthly credit sales are collected as follows and in the corresponding proportion: a. Collected in the month of the sale, 50% b. Collected one month after the sale month, 30% c. Collected the second month after the sale month, 20% 5. Cost Classifications based on 4th quarter information: Raw Materials Used in Manufacturing (See corrected COGS Schedule in Part 1, Required #1) $ Costs Direct Labor Factory Overhead: Rent-Factory Indirect Labor Insurance-Factory (66 2/3%) Utility-Factory (75%) Depreciation-factory building Advertising expense Selling & Administrative Wages and Salaries Utility-Selling & Administrative (25%) Insurance-Administrative (33 1/3%) Depreciation-Administrative PROJECTED RAW MATERIAL PURCHASES Actual Costs on 4th Quarter Income Statement 114,000 General Administrative NEEDED FOR SALES DESIRED ENDING LESS: BEGINNING PURCHASES Oct $34,503 8,626 (40,800) $2,329 Variable Costs Nov $48,304 12,076 (8,626) $51,755 ? 9. Additional monthly obligation paid in cash include: 6. All factory overhead and administrative expenses (except depreciation) are paid in cash in the month the cost is incurred. 7. Direct labor is paid at the end of the month 16,800 8. Raw material purchases are paid as follows: 50% in the month of the purchase, 30% the month after the purchase, and 20% in the second month following the purchase. The raw materials budget is as follows: a. Property taxes, due February 27, 2021: $2,790 b. Employee payroll taxes due March 15, 2021: $900. 5,400 18,000 1,680 Fixed Costs Dec $36,000 $55,205 13,801 (12,076) $56,930 3,630 1,800 18,200 64,000 67,000 720 2,970 27,000 TOTAL QTR $138,012 $111,013
Expert Answer:
Answer rating: 100% (QA)
To prepare a forecasted income statement and a forecasted cash budget for the fourth quarter well ne... View the full answer
Related Book For
Operations and Supply Chain Management
ISBN: 978-0078024023
14th edition
Authors: F. Robert Jacobs, Richard Chase
Posted Date:
Students also viewed these accounting questions
-
Heather Corporation has collected the following information related to its December 31, 2012, balance sheet. Prepare the assets section of Heather Corporation??s balancesheet. Accounts receivable...
-
You are forecasting sales for a company in the fourth quarter of its fiscal year. Your low-end estimate of sales is 14 million, and your high-end estimate is 15 million. You decide to treat all...
-
(Foreign Currency Commitment) U.S. Corporation entered into a contract on November 1, 2017 to sell two machines to International Company for 750,000 foreign currency units (FCU). The machines were to...
-
Explain why each of the following statements about profit-maximizing competitive firms is incorrect. Restate each one correctly. a. A competitive firm will produce output up to the point where price...
-
Find the discounted value of $3800 due in 6 years and 8 months if interest is 7.5% compounded annually.
-
What affects the success of raising a VC fund?
-
True or False: Its completely acceptable to balance a fan with cracks and/ or significant dirt buildup.
-
In January 2014, Wanda transferred machinery worth $200,000 (adjusted basis of $30,000) to a controlled corporation, Oriole, Inc. The transfer qualified under 351. Wanda had deducted $165,000 of...
-
Henrich is a single taxpayer. In 2023, his taxable income is $535,500. What are his income tax and net investment income tax liability in each of the following alternative scenarios? Use Tax Rate...
-
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2022 follow: The firm expects the average wage rate to be $25 per hour in 2022. Spring...
-
Which portfolio is most sensitive and which portfolio is least sensitive to the change from the CAPM to FF3 model? Why? r-squared alpha Market beta Smb beta Hml beta Expected return per month Small...
-
What structural feature allows DNA to store information?
-
Describe the molecular process of X-chromosome inactivation. This description should include the three phases of inactivation and the role of the Xic. Explain what happens to the X chromosomes during...
-
W hat would you predict to be the phenotype of a Drosophila larva whose mother was homozygous for a loss-of-function allele in the nanos gene?
-
The alignment of homologs along the metaphase plate during metaphase of meiosis I is random. In your own words, explain what this means.
-
Scurs in cattle is a sex-influenced trait. A cow with no scurs whose mother had scurs has offspring with a bull with scurs whose father had no scurs. What is the probability of each of the following...
-
For Adita Inc. in Industry I, assume that preferred stock is noncumulative and calculate total dividends paid out to each class of shareholders for each of Years 1, 2, 3, and 4 and the years...
-
1) The government decided to reduce taxes on fast-food to increase revenue. The government assumes that fast-food products have a) An inelastic demand b) An elastic demand c) A demand curve that is...
-
Not all the items in your office supply store are evenly distributed as far as demand is concerned, so you decide to forecast demand to help plan your stock. Past data for legal-sized yellow tablets...
-
Christine has three cars that must be overhauled by her ace mechanic, Megan. Given the following data about the cars, use least slack per remaining operation to determine Megans scheduling priority...
-
Aldo Redondo drives his own car on company business. His employer reimburses him for such travel at the rate of 36 cents per mile. Aldo estimates that his fixed costs per year such as taxes,...
-
What are the differences among an onsite team, a virtual team, a task force, and a committee? What are some of the potential differences in dynamics between people in these different groups?
-
Compare and contrast disciplinary, interdisciplinary, and crossfunctional teams.
-
What are some of the unique challenges associated with teamwork in health care? How do you see teamwork fitting in with the accountable care organization (ACO) mandates? Describe three benefits and...
Study smarter with the SolutionInn App