Prepare the operating forecasts for 2020 and 2021 using the 2019 percent of sales method. (Fill...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare the operating forecasts for 2020 and 2021 using the 2019 percent of sales method. (Fill in the blanks) FCT 2021 1,750,000 20% Forecast 350,000 Actual 2019 FCT 2020 Industry Market share 1,000,000 20% 1,500,000 20% Forecast 300,000 % of sales 200,000 50,000 70,000 Sales Material 25.00% La bour 35.00% 105,000 122,500 Factory Overhead COGS 40,000 160,000 40,000 10,000 20,000 10,000 20.00% 80.00% Gross Profit 20.00% 5.00% Selling Corporate Overhead Operating Profit (op) Taxes (% of OP) 10.00% 5.00% 25.00% 2,500 7,500 Net Income 3.75% % sales Cash 10,000 40,000 5.00% Accounts Receiva ble Inventory Fixed assets 20.00% 10.00% 20,000 200,000 100.00% Total 270,000 Accounts Payable 10.00% 20,000 Debt Plug to Balance Fixed 120,000 120,000 2,500 Common Stock 120,000 120000 Opening RE 10,000 21,250 Net Income 7,500 270,000 Total Questions regarding top-down budget 1. Prepare the forecasts for 2020 and 2021. Note: the 2020 actuals are not complete yet and the CFO needs an estimate to show the CEO. 2. The company uses a job cost system and has specialized labour for its jobs. The Human Resources department has done a great job recruiting talent for each job but there is a lot of competition for this labour. The forecast above is the best guess of what it will cost to attract and retain talent. What type of cost are labour costs in the forecast. If this cost reduces the contribution margin, what happens to break-even sales? 3. What are two benefits of preparing the forecasts or budgets? 4. What is included in a master budget and who may use it? 5. What are two examples of why cash levels can be different than net income for a year? Prepare the operating forecasts for 2020 and 2021 using the 2019 percent of sales method. (Fill in the blanks) FCT 2021 1,750,000 20% Forecast 350,000 Actual 2019 FCT 2020 Industry Market share 1,000,000 20% 1,500,000 20% Forecast 300,000 % of sales 200,000 50,000 70,000 Sales Material 25.00% La bour 35.00% 105,000 122,500 Factory Overhead COGS 40,000 160,000 40,000 10,000 20,000 10,000 20.00% 80.00% Gross Profit 20.00% 5.00% Selling Corporate Overhead Operating Profit (op) Taxes (% of OP) 10.00% 5.00% 25.00% 2,500 7,500 Net Income 3.75% % sales Cash 10,000 40,000 5.00% Accounts Receiva ble Inventory Fixed assets 20.00% 10.00% 20,000 200,000 100.00% Total 270,000 Accounts Payable 10.00% 20,000 Debt Plug to Balance Fixed 120,000 120,000 2,500 Common Stock 120,000 120000 Opening RE 10,000 21,250 Net Income 7,500 270,000 Total Questions regarding top-down budget 1. Prepare the forecasts for 2020 and 2021. Note: the 2020 actuals are not complete yet and the CFO needs an estimate to show the CEO. 2. The company uses a job cost system and has specialized labour for its jobs. The Human Resources department has done a great job recruiting talent for each job but there is a lot of competition for this labour. The forecast above is the best guess of what it will cost to attract and retain talent. What type of cost are labour costs in the forecast. If this cost reduces the contribution margin, what happens to break-even sales? 3. What are two benefits of preparing the forecasts or budgets? 4. What is included in a master budget and who may use it? 5. What are two examples of why cash levels can be different than net income for a year?
Expert Answer:
Answer rating: 100% (QA)
Actual 2019 FCT 2020 FCT 2021 Industry 1000000 1500000 1750000 Market share 0 0 0 of sales Forecast Forecast Sales 200000 300000 350000 Material 2500 50000 75000 87500 Labour 3500 70000 105000 122500 ... View the full answer
Related Book For
Foundations of Finance The Logic and Practice of Financial Management
ISBN: 978-0132994873
8th edition
Authors: Arthur J. Keown, John D. Martin, J. William Petty
Posted Date:
Students also viewed these accounting questions
-
Prepare the operating forecasts for 2020 and 2021 using the 2019 percent of sales method. (Fill in the blanks) FCT 2020 FCT 2021 Actual 2019 1000,000 Industry Market share 20% % of sales Sales...
-
Sales projection for the company ? for 2020 and 2021 , 2022 for 2020 and 2021 , 2022 Consolidated Income Statement 5,000,000 4,000,000 3.000,000 200000 1,000,000 Q4/18 Q1/19 Q2/19 Q3/19 04/19 Q/20...
-
Discuss the shortcomings of the percent of sales method of financial forecasting.
-
A total weighted score of in an External Factor Evaluation (EFE) Matrix indicates that an organization is responding in an outstanding way to existing opportunities and threats in its industry. Oa....
-
Paul Company completed the salary and wage payroll for March 2014. The payroll provided the following details: Salaries and wages earned ...... $200,000 Employee income taxes withheld ..... 40,000...
-
A population of N = 4000 has a population proportion equal to .12. In each of the following cases, which formula will you use to calculate p and why? Using the appropriate formula, calculate p for...
-
The Azuza Company is liquidating. After paying off all of its creditors, the company has \(\$ 1.5\) million to distribute between its preferred stockholders and its common stockholders. The aggregate...
-
Cyber Security Systems had sales of 3,500 units at $75 per unit last year. The marketing manager projects a 30 percent increase in unit volume sales this year with a 40 percent price increase....
-
IT for business Identify TWO input device and explain the usage of input devices in specific business. 1. Define the term, theory, or IT tools. (3marks) 2. Examples of business (min 2 examples) name...
-
Real option analysis can be used to alter the timing, scale, or other aspects of an investment in response to market conditions. Businesses face the dilemma of whether to invest in a project or...
-
The key innovation of the Persians was in the realm of Ophilosophy O art O religion architecture _____ through the teachings of Zoraster.
-
What factors are involved in determining the acceptable level of detection risk for stock balances?
-
What are the three main audit objectives for investments, and why?
-
Why does the audit of fixed assets generally take less time than the audit of current assets? Why is it audited using a predominantly substantive approach?
-
What effects may the acceptable level of detection risk have on substantive tests for reconciling bank accounts?
-
What are the audit objectives for fixed asset transactions and balances?
-
Question 47 Calculate Present Value of a series of $1,000 payments per year for 30 years at 8% annual.
-
Eleni Cabinet Company sold 2,200 cabinets during 2011 at $160 per cabinet. Its beginning inventory on January 1 was 130 cabinets at $56. Purchases made during the year were as follows: February . 225...
-
Callaway Concrete uses Economic Value Added as a financial performance measure. Callaway has $ 240 million in assets, and the firm has financed its assets with 37 percent equity and 63 percent debt...
-
About how many years would it take for your investment to grow fourfold if it were invested at 16 percent compounded semiannually?
-
What different types of businesses operate in the international environment? Why are the techniques and strategies available to these firms different?
-
When incomes rise, the demand for health care _________ because health care is a _________ good.
-
_________ exists in health care when insurance makes a person more likely to engage in more risky behavior and less likely to take preventative measures against illness.
-
Third-party payers attempt to reduce moral hazard problems with _________ and _________.
Study smarter with the SolutionInn App