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....
-
Three years ago, Amy Hessler and her brother-in-law Jacob Seelig opened Family Department Store. For the first two years, business was good, but the following condensed income results for 2016 were...
-
Berg Company adopted a stock-option plan on November 30, 2024, that provided that 70,000 shares of $5 par value stock be designated as available for the granting of options to officers of the...
-
Derive Equation 3.47. 1 Um +. (3.47) G12 Gf12 Gm
-
Inventoriable Costs George Solti, the controller for Garrison Lumber Company, has recently hired you as assistant controller. He wishes to determine your expertise in the area of inventory accounting...
-
On June 1 , Year 1 , Williams Inc. paid $ 4 , 8 0 0 for a two - year insurance policy with coverage beginning that day. How much insurance expense will Williams Inc. report in its Year 1 income...
-
Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller...
-
List the possible orders to join the Rep, Customer, Orders, Order_Line tables when execuring the following SQL query. It uses the database described on page 4. SELECT Item_num, Num_ordered,...
-
Identify five ways in which the independence of an auditor of a large listed company may be strengthened. Intermediate-level exercises
-
Distinguish between dual and cooperative federalism.
-
What ethical issues might arise during the fact-finding process, and how should they be handled?
-
How does jury selection play out?
-
After you talk to the database administrators regarding training, also ask them about: a. Normalization-do they generally normalize to third normal form? Higher? b. In general, how much time is spent...
-
We have a waveform with a pulse duration of 2 us and a listening time of 8 us . What would be the pulse repetition frequency?
-
Do animals have rights? If so, what are they? What duties do human beings have toward animals? Does KFC protect animal welfare at an acceptable level?
-
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?
-
Show all the steps leading to the integral balance equation (18.6) in the text. Use the following boundary conditions and verify Eq. (18.7). (i) At \(y=0, T=T_{\mathrm{S}}\). (ii) At...
-
Consider the flat-plate heat transfer to be solved by the similarity approach. Show all the details leading to Eq. (18.15). What are the boundary conditions on \(\theta\) ? Extend your MATLAB code to...
-
For fluids with \(\operatorname{Pr} <1\) the velocity profile is assumed to be a cubic for \(y
The Mold Survival Guide For Your Home And For Your Health 1st Edition - ISBN: 0801879388 - Free Book
Study smarter with the SolutionInn App