COCA-COLA CONSOLIDATED, INC.CONSOLIDATED STATEMENTS OF OPERATIONS(in thousands, except per share data)Net salesCost of salesGross profitSelling, delivery and administrative expensesIncome from operationsInterest expense, netOther expense, netGain on exchange transactionsIncome (loss) before income taxesIncome tax expense (benefit)Net income (loss)Less: Net income attributable to noncontrolling interestNet income (loss) attributable to Coca-Cola Consolidated, Inc.Basic net income (loss) per share based on net income (loss)attributable to Coca-Cola Consolidated, Inc.:Common StockWeighted average number of Common Stock shares outstandingClass B Common StockWeighted average number of Class B Common Stock shares outstandingDiluted net income (loss) per share based on net income (loss)attributable to Coca-Cola Consolidated, Inc.:Common StockWeighted average number of Common Stock shares outstanding -assuming dilutionClass B Common StockWeighted average number of Class B Common Stock shares outstanding- assuming dilution20194,826,549 $3,156,0471,670,5021,489,748180,75445,990100,53934,22515,66518,5607,18511,375 $1.21 $7,1411.212,2291.219,4171.192,276$$$Fiscal Year20184,625,364 $3,069,6521,555,7121,497,81057,90250,50630,85310,170(13,287)1,869(15,156)4,774(19.930) S(2.13) $7,141(2.13) $2,209(2.13) $9,350(2.13) $2,20920174,287,5882,782,7211,504,8671,403,320101,54741,8699,56512,89363,006(39,841)102,8476,31296,53510.357,14110.352,18810.309,36910.292,228 1. assume that coke budget for a 10% increase in sales over fiscal year 2019.what would budgeted sales be for fiscal year 2020 ? (round 2 decimal places) 2. Assume cokes cost of sales will be 65% of sales, what is cokes budgetedcost of sales for 2020 ? (round 2 decimal places) 3. If coke wants endinginventory to be 10% of the next periods budgeted cost of sales, and the 2021cost of budgeted sales is $3, 796, 080.79 what will be 2020 budgetd endindinginventory be? 4. based on the previous calculations for the coke

The sales budget is a kind of operating budget that helps in estimating the units that will be sold…

1. assume that coke budget for a 10% increase in sales over fiscal year 2019. what would budgeted sales be for fiscal year 2020 ? (round 2 decimal places ) 2. Assume cokes cost of sales will be 65%of sales, what is cokes budgeted cost of sales for 2020 ? (round 2 decimal places ) 3. If coke wants ending inventory to be 10% of the next periods budgeted cost of sales, and the 2021 cost of budgeted sales is $3,796, 080.79 what will be 2020 budgetd endinding inventory be? 4. based on the previous calculations for the coke

1. assume that coke budget for a 10% increase in sales over fiscal year 2019. what would budgeted sales be for fiscal year 2020 ? (round 2 decimal places ) 2. Assume cokes cost of sales will be 65%of sales, what is cokes budgeted cost of sales for 2020 ? (round 2 decimal places ) 3. If coke wants ending inventory to be 10% of the next periods budgeted cost of sales, and the 2021 cost of budgeted sales is $3,796, 080.79 what will be 2020 budgetd endinding inventory be? 4. based on the previous calculations for the coke

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: If a company’s quarterly production budget is for 54,000 units to be produced, its beginning…

A: Step 1: Understanding the information givenProduction = 54,000 unitsBeginning Inventory = 14,400…

Q: Meera Company is preparing its master budget for 2021. Relevant data pertaining to its production,…

A: Production budget shows how many units needs to be produced in order to coverup sales demand and…

Q: If the expected sales volume for the current period is 6,100 units, the desired ending inventory is…

A: The units produced can be solved with the help of cost of goods sold equation

Q: Phoenix Company's 2019 master budget included the following fixed budget report. It is based on an…

A: Solution: Flexible budget is the budget based on various level of activity to know what will be…

Q: 1. assume that coke budget for a 10% increase in sales over fiscal year 2019. what would budgeted…

A: The sales budget makes the company competent to manage its resources effectively and earn the…

Q: You Matter and Make a Difference (YMMD) is in the process of budgeting for the total number of units…

A: Units produced means the number of units that are made by the entity during a period. It is…

Q: 8) Avery is planning to purchase inventory for resale costing $100,000 in July. $150,000 in August…

A: 8) The company's aim will be to increase the profitability of the company. The profits can be…

Q: None

A: The budgeted sales is computed by multiplying the units sold by the sales price. The budgeted…

Q: PT Classic Kingdom is in the process of making the production budget for 2021. The production…

A: NOTE : As per BARTLEBY guidelines, when multiple questions are given, then first question is to be…

Q: Coronado Industries had sales in 2021 of $5,521,600 and gross profit of $893,200. Management is…

A: The question is based on the concept of Cost Accounting.

Q: Prepare a sales budget for 2022 under each plan. (Round Unit selling price answers to 2 decimal…

A: Budgeting is a process to plan how to, where and how much company should spend money for a future…

Q: Rak Sarang Corporation expects to sell 5,000 units in the first year, followed by a 300-unit…

A: Particulars Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Forecasted sales (units)…

Q: Sheldon Industries' sales budget shows quarterly sales for 2020 as follows: Quarter First Second…

A: Production budget is used for the identification and estimation of the cost. It determines how much…

Q: Using Actual Results for 2020, Prepare Budgeted Income Statement for 2021 2020 Revenues Actual Sales…

A: Budgeted Income statement for 2021 Particulars Amount in $ Revenue Sale of equipment…

Q: A. What are the total expected cash collections for the year under revised budget ? B. What is the…

A: Budget: A budget is an estimation to determine the income that will be earned and expenses that will…

Q: Your department is budgeting miscellaneous expenses for the next 5 years. Your best guess at the…

A: Current expenses = $14,500 Annual inflation rate = 3.9% MARR = 15% The expenses in then-current…

Q: Put tigether a production budget please! On January 1, 2022, the Vaughn Company budget committee has…

A: PRODUCTION BUDGETThe budget is prepared to estimate the requirements for the future period. The…

Q: Budgeted costs for the year 2019 Fixed cost Variable cost Costs of: (per year) $ (per case)…

A: Budgeting is a process of estimating the possible outcomes in advance which includes the sources of…

Q: None

A: To create a cash flow budget for October 2023 based on the given information, we need to analyze the…

Q: Budgeted Selling Expenses Sales Commission Freight-out Total Selling Expenses Budgeted…

A: A budget is a forecast of revenue and expenses for a certain future period of time that is generally…

Concept explainers

Master Budget

A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.

Sales Budget and Selling

A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.

Question

COCA-COLA CONSOLIDATED, INC.
CONSOLIDATED STATEMENTS OF OPERATIONS
(in thousands, except per share data)
Net sales
Cost of sales
Gross profit
Selling, delivery and administrative expenses
Income from operations
Interest expense, net
Other expense, net
Gain on exchange transactions
Income (loss) before income taxes
Income tax expense (benefit)
Net income (loss)
Less: Net income attributable to noncontrolling interest
Net income (loss) attributable to Coca-Cola Consolidated, Inc.
Basic net income (loss) per share based on net income (loss)
attributable to Coca-Cola Consolidated, Inc.:
Common Stock
Weighted average number of Common Stock shares outstanding
Class B Common Stock
Weighted average number of Class B Common Stock shares outstanding
Diluted net income (loss) per share based on net income (loss)
attributable to Coca-Cola Consolidated, Inc.:
Common Stock
Weighted average number of Common Stock shares outstanding -
assuming dilution
Class B Common Stock
Weighted average number of Class B Common Stock shares outstanding
- assuming dilution
2019
4,826,549 $
3,156,047
1,670,502
1,489,748
180,754
45,990
100,539
34,225
15,665
18,560
7,185
11,375 $
1.21 $
7,141
1.21
2,229
1.21
9,417
1.19
2,276
$
$
$
Fiscal Year
2018
4,625,364 $
3,069,652
1,555,712
1,497,810
57,902
50,506
30,853
10,170
(13,287)
1,869
(15,156)
4,774
(19.930) S
(2.13) $
7,141
(2.13) $
2,209
(2.13) $
9,350
(2.13) $
2,209
2017
4,287,588
2,782,721
1,504,867
1,403,320
101,547
41,869
9,565
12,893
63,006
(39,841)
102,847
6,312
96,535
10.35
7,141
10.35
2,188
10.30
9,369
10.29
2,228

1. assume that coke budget for a 10% increase in sales over fiscal year 2019.
what would budgeted sales be for fiscal year 2020 ? (round 2 decimal places
) 2. Assume cokes cost of sales will be 65% of sales, what is cokes budgeted
cost of sales for 2020 ? (round 2 decimal places) 3. If coke wants ending
inventory to be 10% of the next periods budgeted cost of sales, and the 2021
cost of budgeted sales is $3, 796, 080.79 what will be 2020 budgetd endinding
inventory be? 4. based on the previous calculations for the coke

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction to sales budget:

VIEW

Step 2: Requirement 1- Determination of budgeted sales for 2020:

VIEW

Step 3: Requirement 2- Determination of budgeted cost of sales in 2020:

VIEW

Step 4: Requirement 3- Calculation of ending inventory in 2020:

VIEW

Solution

VIEW

Step by step

Solved in 5 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

What is the multiple choice answer for numbers 7 8 and 9?
Click Draperies makes and sells curtains. Information related to its performance in 2020 is given below: (Click the icon to view the data.) Calculate Click Draperies' flexible budget for (a) revenues, (b) variable costs, (c) fixed costs, and (d) operating income. Calculate Click's flexible budget for (a) revenues. Begin by determining the formula and then solve for the amount. Actual units sold 1,560 X Budgeted selling price per unit = Flexible budget for revenues × $ 361,920 232 Calculate Click's flexible budget for (b) variable costs. Begin by determining the formula and then solve for the amount. Actual units sold 1,560 X Budgeted variable cost per unit × $ 108 = Calculate Click's flexible budget for (c) fixed costs. Click's flexible budget for fixed costs is $ 73,000. = = Flexible budget for variable costs 168,480 Calculate Click's flexible budget for (d) operating income. Begin by determining the formula and then solve for the amount. (Abbreviations used: rev = revenue, vc =…
PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS PLEASE, DO IT IN EXCEL AND SHOW THE FORMULASIn preparing the cash budgeting projected balance method, it is necessary to calculate the amount of the inventory balance. The following information is available for the current fiscal year: Inventory balance, $200,000.00, it is known that the inventory turnover is every 60 days. The Cost of Sales is forecasted to increase 15% for the next fiscal year. What is the budgeted inventory balance
Please help me with show all calculation thanku
Coronado Industries had sales in 2021 of $5,521,600 and gross profit of $893,200. Management is considering two alternative budget plans to increase its gross profit in 2022.Plan A would increase the unit selling price from $8.00 to $8.40. Sales volume would decrease by 101,500 units from its 2021 level. Plan B would decrease the unit selling price by $0.50. The marketing department expects that the sales volume would increase by 105,560 units.At the end of 2021, Coronado has 32,480 units of inventory on hand. If Plan A is accepted, the 2022 ending inventory should be 28,420 units. If Plan B is accepted, the ending inventory should be equal to 48,720 units. Each unit produced will cost $1.5 in direct labor, $1.3 in direct materials, and $1.2 in variable overhead. The fixed overhead for 2022 should be $1,538,740.
Subject: accounting
If OMS continues to sell through the independent sales agents and pays the higher commission rate (20% instead of 15%), compute the estimated sales dollars that would be required to generate the level of profit as projected in the budgeted income statement.
Schedules of Expected Cash Collections and Disbursements; Budgeted Income Statement and Budgeted Balance Sheet. Crow Enterprises is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Crow Enterprises Balance Sheet June 30 Assets $ 80,000 135,000 41,250 Plant and equipment, net of depreciation_211,000 $ 457,250 Cash Accounts receivable Inventory Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings $ 72,000 345,000 50,250 Total liabilities and stockholders' equity $ 467,250 Crow's managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $220,000, $240,000, $230,000, and $250,000, respectively. 2. All sales are on credit and all credit sales are collected. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the…
(J) please answer ASap... Question 1 The following table presents selected information for Superior Flooring's monthly production budgets for the coming year. Superior's inventory policy is to have ending inventory equal to 10% of the next month's sales. What is the beginning inventory in June? A. 350 B. 310 C. 250 D. 340 Question 2 Which of the following statements is true? A. A budget reconciliation report shows the difference between actual profit and budgeted profit and does not show the other variances. B. Activity-based costing is not used to evaluate customer profitability. C. Sales quantity (budgeted sales volume vs. actual sales volume) is the only item which differs between the master budget and the flexible budget. D. Comparing the flexible budget to the as-if budget isolates a change in input price (e.g. budgeted input price vs. actual input price). Question 3 Which of the following is not a benefit of budgeting? A. It reduces the need for analysis with regard to company…
Concord Company estimates that 2022 sales will be $34,400 in quarter 1, $41,280 in quarter 2, and $49,880 in quarter 3. Cost of goods sold is 50% of sales. Management desires to have ending merchandise inventory equal to 10% of the next quarter's expected cost of goods sold. Prepare a merchandise purchases budget by quarter for the first 6 months of 2022. v: v ✓ CONCORD COMPANY Merchandise Purchases Budget $ $ 1 Quarter $ $ 2 $ Six Months
If it can be done in excel, please, I would appreciate it very much (and show the formulas).In preparing the cash budgeting projected balance method, it is necessary to calculate the amount of the inventory balance. The following information is available for the current fiscal year: Inventory balance, $200,000.00, it is known that the inventory turnover is every 60 days. The Cost of Sales is forecasted to increase 15% for the next fiscal year. What is the budgeted inventory balance