Tom Randall, President and founder of Randalls Rewriteable CDs, has a problem. The 2021 fiscal year begins on April 1st and Tom has to have the Quarter 1 2021 master budget ready to be presented to the Board of Directors at 9 a.m. on April 1st. Unfortunately, many of the numbers needed to prepare the budget will not be available until late in the day on March 31st.

It seemed like an impossible task, but Tom came up with a solution. He called you, his new intern, into his office and said, We need to start working on the Quarter 1 2021 master budget today. Some of the numbers wont be available until later, but we can do a lot of the work in advance. Ive got a really important assignment for you!

Tom explained the assignment as follows. I want you to create an Excel workbook so that, as soon as we enter the missing data, the workbook will calculate the Quarter 1 2021 budget on the spot. Then all I have to do on April 1st is enter the missing data and print the workbook for the Board. You looked a little bewildered, and asked, Just what is it that we dont know? Tom handed you a sheet of paper with the following list of data

Actual sales revenues, 4^th quarter 2020

Actual cost of ABS (plastic) purchased, 4^th quarter 2020

Cost formula for 2021 manufacturing overhead costs

Cost formula for 2021 selling and administrative costs Projected number of cases of CDs to be sold

Selling price of a case of CDs

Cost of ABS per pound

Direct labor rate per hour

Dont be too overwhelmed by this, Tom continued. I realize that there is a lot we dont know right now, but there is a lot more that we do know about our 2021 budget. Just take a look at the list of information I prepared for you. With that, Tom handed you yet another sheet of paper.

1) The sales manager will not have projections of 2021 sales ready until the last minute, but we always expect sales to follow this pattern:

April sales 40% of first quarter 2021 sales

May sales 35% of first quarter 2021 sales

June sales 25% of first quarter 2021 sales

July sales 110% of June 2021 sales

August sales 130% of July 2021 sales

In addition, it is safe to estimate first quarter 2021 sales at 120% of fourth quarter 2020 sales.

2. Last year, a case of CDs (10 CDs) sold for $35. However, because of the ever-increasing productivity and competition in this market, it is expected that we will have to reduce our selling price. This change in price will not be known until April 1^st.

3. All sales are on account. Typically, 60% of our customers pay their bills during the same month that they buy the CDs, 25% do not pay until the month after the purchase, and 12% pay two months after the purchase. The remaining 3% are uncollectible. The Accounts Receivable balance, net of uncollectible accounts, is expected to be $80,000 on April 1^st. (Assume that 62.5% of this balance will be collected in April with the remainder to be collected in May.)

4. Because our sales projections are not always perfect and production lead time, we want to maintain an ending inventory of CDs equal to 15% of the following months sales. You can assume that we will have sufficient CDs on hand on March 31st to meet this requirement.

5. The production department supervisor informs us that 0.75 pounds of ABS are needed to produce a case of CDs. Our purchasing agent will not know the cost of a pound of ABS until mid-March. Over the last 6 months, suppliers have been increasing their prices of ABS as a result of rising petroleum prices, a key ingredient in ABS. In addition, the only acceptable grade of ABS is often in short supply, so we need to make sure that enough ABS is on hand at the beginning of each month to meet 30% of that months production needs. You can assume that there will be enough ABS on hand on April 1st to meet this requirement.

6. Given our monthly purchasing patterns and credit terms with suppliers, historically we have paid for 40% of our ABS purchases in the month in which the purchase is made. The remaining 60% is paid for during the following month. The controller tells me that the April 1^st accounts payable balance should be $24,000.

7. We will know the direct labor rate per hour as soon as negotiations with the union are complete, but there is no way to predict when that might happen. However, the production department supervisor tells us that it takes 0.40 hours to make a case of CDs.

8) Our cash balance on April 1^st is not known at this point. However, the controller has informed us that in addition to the cash disbursements necessary to support normal operating expenses, the production department is in need of a new CD press. The Board of Directors has given approval for the purchase of the new press at the end of June. Also, the Board declares dividends of $15,000 in the first month of each quarter to be paid in the second month of that quarter. Depreciation expense for factory related assets totals $25,000 a month, and $8,000 a month for selling and administrative assets.

9) The Board of Directors of Randalls Rewriteable CDs does not want you to prepare all of the schedules and exhibits in Chapter 8 of your textbook for its meeting on April 1st. However, you should use them as a guide while you are completing each of the required elements of your 2021 master budget workbook.

Tom continued, I prepared a file so that you can get to work on the workbook right away. The file named Excel Project Budget. In this file, the first sheet (called DATA) is where I will enter the missing data on April 1st. I named all of the sheets so that you know where to put the master budget schedules and also typed the text into each schedule. All you have to do is write formulae to calculate the numbers and format the individual budgets. For control purposes, you must return the file to me when the project is complete via email. There is a secret code in the workbook so that I can be sure that you do your own work.

As you began to walk away, Tom stopped you and made one last comment. Remember, I wont know the missing data until the very last second. Im not going to have time to check your work before the Board sees it, so it is crucial that the budget is attractively prepared as well as computationally correct. I put together a list of formatting instructions to help you make both of us look good. If you have any problems, stop by my office and Ill help if I can. Dont underestimate how long this is going to take. Get to work and GOOD LUCK.

7%O % Mon Oct 25 5:21 AM Q OFF Excel File Edit View Insert Format Tools Data Window Window Help AutoSave A evo ... Copy of budget excel templates 2021.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Arial === 2 10 General Conditional Formatting , Format as Table BI a~A~ A $ % ) 2.0 Cell Styles Share Comments Insert v V y , Ayu O o DX Delete v v v Paste .00 V V Sensitivity # Sort & & Filter Format Find & Select Analyze Data A14 X fx C D E F F G H I J K L L M N 0 P Q R S T U V V 36000 34 12 25 90000 PER MONTH + 2.1 PER CASE PRODUCED 70000 PER MONTH + 0.6 PER CASE SOLD A 1 ACTUAL CASES SOLD, FOURTH QUARTER 2020 2 SELLING PRICE PER CASE, FIRST QUARTER 2021 4 5 COST OF ABS PER POUND, FIRST QUARTER 2021 6 DIRECT LABOR RATE PER HOUR, FIRST QUARTER 2021 8 9 10 11 12 13 14 15 16 17 18 19 COST FORMULA FOR MANUFACTURING OVERHEAD COSTS 20 21 COST FORMULA FOR SELLING & ADMINISTRATIVE EXPENSES 22 23 CASH BALANCE, APRIL 1 24 25 COST OF NEW CD PRESS 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 . 40000 52000 DATA SALES MAT OTHER CASHBUD INCSTMT CHECKFIGURES + Ready 3 + 85% OCT 25 all W SA 7%O % Mon Oct 25 5:21 AM Q Excel File Edit View View Insert Format Format Tools AutoSave A evo ... Data Window Help Copy of budget excel templates 2021.xls - Compatibility Mode OFF Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments H V Arial Insert v 10 ~ A V === abe General Conditional Formatting 2 Format as Table Cell Styles , zov o O DX Delete v v WES v Paste BI av A. Av $ % ) O .00 2.0 V Analyze Sensitivity # Sort & Filter Find & Select Format V Data A17 fx May E F G H J K L M N O Q R S U 1ST QTR TOTAL JULY AUG A B D 1 SCHEDULE 1. SALES BUDGET 2 3 APR MAY JUNE 4 Number of Cases of CDs to be sold 5 Selling price per case 6 Total Sales Revenue 7 8 9 10 11 12 SCHEDULE 2. SCHEDULE OF EXPECTED CASH COLLECTIONS 13 14 APR MAY JUNE 15 April 1 Accounts Receivable 16 April 17 May 18 June 19 Cash Collections 20 21 22 23 24 1ST QTR. TOTAL JULY AUG 25 26 27 28 29 30 31 32 33 34 DATA SALES MAT OTHER CASHBUD INCSTMT CHECKFIGURES + Ready 31 OCT 25 all W SA Excel File Edit View Insert Format Format Tools 7%O % Mon Oct 25 5:21 AM Q Data Window Help Copy of budget excel templates 2021.xls - Compatibility Mode AutoSave OFF A evo ... Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 10 . Al V Insert v V General === Conditional Formatting Format as Table Cell Styles ru O 0 DX Delete v v v Paste BIU avA V $ % ) V .00 2.0 Sort & 8 Filter Sensitivity Format Find & Select Analyze Data V C6 fx A B D E F G H I J L M N 0 Q R S U 1ST QTR. TOTAL JULY 1ST QTR. TOTAL 10 11 SCHEDULE 3. DIRECT MATERIALS BUDGET 12 13 14 APR MAY JUNE 15 Number of cases of CDs to be produced 16 Pounds of ABS needed per case 17 Pounds of ABS needed for production 18 Desired ending inventory 19 Total pounds of ABS needed 20 Desired beginning inventory 21 Pounds of ABS to be purchased 22 Cost per pound of ABS 23 Total cost of ABS to be purchased 24 25 26 SCHEDULE 4. SCHEDULE OF EXPECTED CASH DISBURSMENTS 27 28 APR MAY JUNE 29 April 1 Accounts Payable 30 April 31 May 32 June 33 34 Total Cash Disbursements for Material 35 36 37 38 39 40 41 42 43 44 45 46 DATA SALES MAT OTHER Ready CASHBUD INCSTMT CHECKFIGURES + 3 OCT 25 ))) W SA - BOERRERODROM 7%O % Mon Oct 25 5:21 AM Q OFF Share Comments Excel File Edit View Insert Format Tools Data Window Help AutoSave A evo ... Copy of budget excel templates 2021.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Arial === 10 ~ A General Conditional Formatting , Format as Table BIU a~A~ $ %) 2.0 Cell Styles B25 Xfx APR Insert v V V , zov o WES O v Paste .00 DX Delete v v Format Sort & & Filter Analyze V Find & Select Sensitivity Data A B D E F H I J K L M . N O Q R S S MAY 1ST QTR TOTAL JUNE 1 SCHEDULE 5. DIRECT LABOR BUDGET 2 3 APR 4 Number of cases of CDs to be produced Direct labor hours per case 6 Total direct labor hours needed 7 Direct labor rate per hour 8 Total cash needed for direct labor expense 9 10 11 SCHEDULE 6. MANUFACTURING OVERHEAD BUDGET 12 13 APR 14 Number of cases of CDs to be produced 15 Variable overhead rate per case 16 Budgeted variable manufacturing overhead 17 Budgeted fixed manufacturing overhead 18 Total budgeted manufacturing overhead 19 Non-cash expenses 20 Total cash needed for manufacturing overhead expense 21 22 23 SCHEDULE 7. SELLING AND ADMINISTRATIVE EXPENSE BUDGET MAY 1ST QTR TOTAL JUNE 24 1ST QTR. TOTAL APR MAY JUNE 25 26 Number of cases of CDs to be sold 27 Variable S&A expense per case 28 Budgeted Variable S&A Expense 29 Budgeted Fixed S&A Expense 30 Total Budgeted S&A exp[ense 31 Non-cash expenditures 32 Total cash needed for S&A expenses 33 34 35 36 37 DATA SALES MAT OTHER CASHBUD INCSTMT CHECKFIGURES + Ready Count: 3 cm OCT 25 cal W x NO BRETONDON 7%O % Mon Oct 25 5:21 AM Q Excel File Edit View View Insert Format Format Tools AutoSave A evo ... Data Window Help Copy of budget excel templates 2021.xls - Compatibility Mode OFF Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v Arial V H 10 ~ ' ' General V [C === abe , Conditional Formatting Format as Table Cell Styles Ayu O DX Delete v v > OM v Paste BIU a~A~ Av V $ % ) .00 2.0 Sensitivity V Format Sort & Filter Find & Select Analyze Data B22 fx A B C D E E F G H J K L M N O Q R S S U U 1ST QTR. TOTAL APR MAY JUNE 1 SCHEDULE 8. CASH BUDGET 2 3 4 Beginning cash balance Cash collections 6 Total cash available 7 8 Cash disbursements: 9 Operating expenses 10 Material Purchases 11 Direct labor expenses 12 Manufacturing overhead expenses 13 Selling and administrative expenses 14 Total operating expenses 15 Extra expenses 16 Purchase of new CD press 17 Dividend payment 18 Total extra expenses 19 20 Total cash disbursements 21 22 Ending cash balance 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 DATA SALES ni MAT OTHER CASHBUD INCSTMT CHECKFIGURES + Ready 3 OCT 25 W SA BOER RESOSEDOM 7%O % Mon Oct 25 5:21 AM Q OFF Excel File Edit View View Insert Format Format Tools Data Window Help AutoSave A evo ... Copy of budget excel templates 2021.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me === abe Arial 10 Conditional Formatting General [C , Format as Table BIU Av $ % ) & 2.0 Cell Styles Share Comments Insert v V H V OM Ayu O DX Delete v v v Paste .00 EN V V Sort & Filter Sensitivity Find & Select ! Format Analyze Data C3 fx APR F G H I J L M N O Q R S T U 1ST QTR TOTAL A B D E 1 SCHEDULE 9. BUDGETED CONTRIBUTION BASIS INCOME STATEMENT 2 PER 3 UNIT APR MAY JUNE 4 Number of cases of CDs sold NA 5 Selling price per case 6 Total Sales Revenues NA 7 8 Variable expenses: 9 Direct material 10 Direct labor 11 Variable Manufacturing overhead 12 Variable S&A expenses 13 Total Variable Costs 14 15 Contribution margin 16 17 Fixed expenses: NA 18 Fixed manufacturing overhead NA 19 Fixed S&A expense NA 20 Total fixed costs NA 21 22 Net income NA 23 24 25 26 27 28 29 30 31 32 33 34 DATA SALES MAT OTHER CASHBUD INCSTMT CHECKFIGURES + Ready Count: 3 31 OCT 25 all W X - Excel File Edit View Insert Format Format Tools 7%O % Mon Oct 25 5:21 AM Q Data Window Help Copy of budget excel templates 2021.xls - Compatibility Mode AutoSave OFF Ao C... Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Comic Sans MS 10 V Insert v [C ' ' A === abe , General Conditional Formatting Format as Table Cell Styles ru O o zov DX Delete v v > OM v Paste a. A ~ A V $ % ) .00 2.0 V Sort & Filter Format Find & Select Analyze Data Sensitivity A2 X fx =DATAIA1 A B D E G H I T J K L L M N O P Q R S . T U V F 1ST QTR TOTAL APR MAY JUNE - - - 13 14 15 Total Sales Revenue 16 Cash Collections 17 Number of cases of CDs to be produced 18 Total cost of ABS to be purchased 19 Total Cash Disbursements for Material 20 Total cash needed for direct labor expense 21 Total cash needed for manufacturing overhead expense 22 Total cash needed for S&A expenses 23 Ending cash balance 24 Net income 25 26 27 28 29 - 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 DATA SALES MAT OTHER CASHBUD INCSTMT CHECKFIGURES + Ready 31 OCT 25 all W SA - BARBEROREDAD 7%O % Mon Oct 25 5:21 AM Q OFF Excel File Edit View Insert Format Tools Data Window Window Help AutoSave A evo ... Copy of budget excel templates 2021.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Arial === 2 10 General Conditional Formatting , Format as Table BI a~A~ A $ % ) 2.0 Cell Styles Share Comments Insert v V y , Ayu O o DX Delete v v v Paste .00 V V Sensitivity # Sort & & Filter Format Find & Select Analyze Data A14 X fx C D E F F G H I J K L L M N 0 P Q R S T U V V 36000 34 12 25 90000 PER MONTH + 2.1 PER CASE PRODUCED 70000 PER MONTH + 0.6 PER CASE SOLD A 1 ACTUAL CASES SOLD, FOURTH QUARTER 2020 2 SELLING PRICE PER CASE, FIRST QUARTER 2021 4 5 COST OF ABS PER POUND, FIRST QUARTER 2021 6 DIRECT LABOR RATE PER HOUR, FIRST QUARTER 2021 8 9 10 11 12 13 14 15 16 17 18 19 COST FORMULA FOR MANUFACTURING OVERHEAD COSTS 20 21 COST FORMULA FOR SELLING & ADMINISTRATIVE EXPENSES 22 23 CASH BALANCE, APRIL 1 24 25 COST OF NEW CD PRESS 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 . 40000 52000 DATA SALES MAT OTHER CASHBUD INCSTMT CHECKFIGURES + Ready 3 + 85% OCT 25 all W SA 7%O % Mon Oct 25 5:21 AM Q Excel File Edit View View Insert Format Format Tools AutoSave A evo ... Data Window Help Copy of budget excel templates 2021.xls - Compatibility Mode OFF Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments H V Arial Insert v 10 ~ A V === abe General Conditional Formatting 2 Format as Table Cell Styles , zov o O DX Delete v v WES v Paste BI av A. Av $ % ) O .00 2.0 V Analyze Sensitivity # Sort & Filter Find & Select Format V Data A17 fx May E F G H J K L M N O Q R S U 1ST QTR TOTAL JULY AUG A B D 1 SCHEDULE 1. SALES BUDGET 2 3 APR MAY JUNE 4 Number of Cases of CDs to be sold 5 Selling price per case 6 Total Sales Revenue 7 8 9 10 11 12 SCHEDULE 2. SCHEDULE OF EXPECTED CASH COLLECTIONS 13 14 APR MAY JUNE 15 April 1 Accounts Receivable 16 April 17 May 18 June 19 Cash Collections 20 21 22 23 24 1ST QTR. TOTAL JULY AUG 25 26 27 28 29 30 31 32 33 34 DATA SALES MAT OTHER CASHBUD INCSTMT CHECKFIGURES + Ready 31 OCT 25 all W SA Excel File Edit View Insert Format Format Tools 7%O % Mon Oct 25 5:21 AM Q Data Window Help Copy of budget excel templates 2021.xls - Compatibility Mode AutoSave OFF A evo ... Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 10 . Al V Insert v V General === Conditional Formatting Format as Table Cell Styles ru O 0 DX Delete v v v Paste BIU avA V $ % ) V .00 2.0 Sort & 8 Filter Sensitivity Format Find & Select Analyze Data V C6 fx A B D E F G H I J L M N 0 Q R S U 1ST QTR. TOTAL JULY 1ST QTR. TOTAL 10 11 SCHEDULE 3. DIRECT MATERIALS BUDGET 12 13 14 APR MAY JUNE 15 Number of cases of CDs to be produced 16 Pounds of ABS needed per case 17 Pounds of ABS needed for production 18 Desired ending inventory 19 Total pounds of ABS needed 20 Desired beginning inventory 21 Pounds of ABS to be purchased 22 Cost per pound of ABS 23 Total cost of ABS to be purchased 24 25 26 SCHEDULE 4. SCHEDULE OF EXPECTED CASH DISBURSMENTS 27 28 APR MAY JUNE 29 April 1 Accounts Payable 30 April 31 May 32 June 33 34 Total Cash Disbursements for Material 35 36 37 38 39 40 41 42 43 44 45 46 DATA SALES MAT OTHER Ready CASHBUD INCSTMT CHECKFIGURES + 3 OCT 25 ))) W SA - BOERRERODROM 7%O % Mon Oct 25 5:21 AM Q OFF Share Comments Excel File Edit View Insert Format Tools Data Window Help AutoSave A evo ... Copy of budget excel templates 2021.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Arial === 10 ~ A General Conditional Formatting , Format as Table BIU a~A~ $ %) 2.0 Cell Styles B25 Xfx APR Insert v V V , zov o WES O v Paste .00 DX Delete v v Format Sort & & Filter Analyze V Find & Select Sensitivity Data A B D E F H I J K L M . N O Q R S S MAY 1ST QTR TOTAL JUNE 1 SCHEDULE 5. DIRECT LABOR BUDGET 2 3 APR 4 Number of cases of CDs to be produced Direct labor hours per case 6 Total direct labor hours needed 7 Direct labor rate per hour 8 Total cash needed for direct labor expense 9 10 11 SCHEDULE 6. MANUFACTURING OVERHEAD BUDGET 12 13 APR 14 Number of cases of CDs to be produced 15 Variable overhead rate per case 16 Budgeted variable manufacturing overhead 17 Budgeted fixed manufacturing overhead 18 Total budgeted manufacturing overhead 19 Non-cash expenses 20 Total cash needed for manufacturing overhead expense 21 22 23 SCHEDULE 7. SELLING AND ADMINISTRATIVE EXPENSE BUDGET MAY 1ST QTR TOTAL JUNE 24 1ST QTR. TOTAL APR MAY JUNE 25 26 Number of cases of CDs to be sold 27 Variable S&A expense per case 28 Budgeted Variable S&A Expense 29 Budgeted Fixed S&A Expense 30 Total Budgeted S&A exp[ense 31 Non-cash expenditures 32 Total cash needed for S&A expenses 33 34 35 36 37 DATA SALES MAT OTHER CASHBUD INCSTMT CHECKFIGURES + Ready Count: 3 cm OCT 25 cal W x NO BRETONDON 7%O % Mon Oct 25 5:21 AM Q Excel File Edit View View Insert Format Format Tools AutoSave A evo ... Data Window Help Copy of budget excel templates 2021.xls - Compatibility Mode OFF Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v Arial V H 10 ~ ' ' General V [C === abe , Conditional Formatting Format as Table Cell Styles Ayu O DX Delete v v > OM v Paste BIU a~A~ Av V $ % ) .00 2.0 Sensitivity V Format Sort & Filter Find & Select Analyze Data B22 fx A B C D E E F G H J K L M N O Q R S S U U 1ST QTR. TOTAL APR MAY JUNE 1 SCHEDULE 8. CASH BUDGET 2 3 4 Beginning cash balance Cash collections 6 Total cash available 7 8 Cash disbursements: 9 Operating expenses 10 Material Purchases 11 Direct labor expenses 12 Manufacturing overhead expenses 13 Selling and administrative expenses 14 Total operating expenses 15 Extra expenses 16 Purchase of new CD press 17 Dividend payment 18 Total extra expenses 19 20 Total cash disbursements 21 22 Ending cash balance 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 DATA SALES ni MAT OTHER CASHBUD INCSTMT CHECKFIGURES + Ready 3 OCT 25 W SA BOER RESOSEDOM 7%O % Mon Oct 25 5:21 AM Q OFF Excel File Edit View View Insert Format Format Tools Data Window Help AutoSave A evo ... Copy of budget excel templates 2021.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me === abe Arial 10 Conditional Formatting General [C , Format as Table BIU Av $ % ) & 2.0 Cell Styles Share Comments Insert v V H V OM Ayu O DX Delete v v v Paste .00 EN V V Sort & Filter Sensitivity Find & Select ! Format Analyze Data C3 fx APR F G H I J L M N O Q R S T U 1ST QTR TOTAL A B D E 1 SCHEDULE 9. BUDGETED CONTRIBUTION BASIS INCOME STATEMENT 2 PER 3 UNIT APR MAY JUNE 4 Number of cases of CDs sold NA 5 Selling price per case 6 Total Sales Revenues NA 7 8 Variable expenses: 9 Direct material 10 Direct labor 11 Variable Manufacturing overhead 12 Variable S&A expenses 13 Total Variable Costs 14 15 Contribution margin 16 17 Fixed expenses: NA 18 Fixed manufacturing overhead NA 19 Fixed S&A expense NA 20 Total fixed costs NA 21 22 Net income NA 23 24 25 26 27 28 29 30 31 32 33 34 DATA SALES MAT OTHER CASHBUD INCSTMT CHECKFIGURES + Ready Count: 3 31 OCT 25 all W X - Excel File Edit View Insert Format Format Tools 7%O % Mon Oct 25 5:21 AM Q Data Window Help Copy of budget excel templates 2021.xls - Compatibility Mode AutoSave OFF Ao C... Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Comic Sans MS 10 V Insert v [C ' ' A === abe , General Conditional Formatting Format as Table Cell Styles ru O o zov DX Delete v v > OM v Paste a. A ~ A V $ % ) .00 2.0 V Sort & Filter Format Find & Select Analyze Data Sensitivity A2 X fx =DATAIA1 A B D E G H I T J K L L M N O P Q R S . T U V F 1ST QTR TOTAL APR MAY JUNE - - - 13 14 15 Total Sales Revenue 16 Cash Collections 17 Number of cases of CDs to be produced 18 Total cost of ABS to be purchased 19 Total Cash Disbursements for Material 20 Total cash needed for direct labor expense 21 Total cash needed for manufacturing overhead expense 22 Total cash needed for S&A expenses 23 Ending cash balance 24 Net income 25 26 27 28 29 - 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 DATA SALES MAT OTHER CASHBUD INCSTMT CHECKFIGURES + Ready 31 OCT 25 all W SA - BARBEROREDAD