Homework Help is Here – Start Your Trial Now!
Business
Accounting
Home Insert Draw Page Layout Formulas Data Review View Automate Developer Calibri (Body) 12 ✓ Α Αν Conditional Formatting ✓ ☑Insert v Σ Custom Paste B I U ✓ ✓ $ ✓ %9 0 .00 →0 Format as Table ✓ Cell Styles ▾ Delete ✓ Format ✓ C26 fx A B D E F G 1 Instruction: 2 1. Please complete the following budget plan using appropriate cell references format (the cells highlighted in grey) 3 2. Please use fill handler to complete the table. E.g. in cell C16, build one formula and generate other formulas to D16 and E16 with fill handler. 4 3. For "Cost of Goods Sold" section (before "COGS Subtotal"), build one formula in cell C19, and generate formulas until E21. Overhead (B21) is 20% (B10) of the labor cost (B20). 5 4. For "COGS Subtotal", build one formula in C22, and generate the formulas to E22. 6 5. Similar requirements for "Selling Expenses" and "Projected Earnings" section. 7 6. Please be noted, for all items under "Cost of Goods Sold", and "Selling Expenses" the cost is per ONE shoe, not per pair. 8 Number of Shoes Quarter Budget 9 Per Pair 2 20% 10 Overhead % of Labor 11 12 13 Sales Volume - #pairs: 14 Selling Price Per Pair: 15 Item 16 Revenue 17 18 Cost of Goods Sold (per one shoe): 19 Materials 20 Direct Labor 21 Overhead 22 COGS Subtotal 23 24 Selling Expense (per one shoe) 25 26 Projected Earnings 27 Low Priced Medium Priced High Priced $ 1,200 180 780 $ 200 $ 360 230 Low Priced Total Medium Priced Total 216000 $ 156,000 $ High Priced Total 82,800 Costs per Shoe $ 46.20 10.28 2 2 8.00 ✓ Comments Share ✓ Sort & Filter Find & Select Sensitivity Add-ins Analyze Data H J K L M

Home Insert Draw Page Layout Formulas Data Review View Automate Developer Calibri (Body) 12 ✓ Α Αν Conditional Formatting ✓ ☑Insert v Σ Custom Paste B I U ✓ ✓ $ ✓ %9 0 .00 →0 Format as Table ✓ Cell Styles ▾ Delete ✓ Format ✓ C26 fx A B D E F G 1 Instruction: 2 1. Please complete the following budget plan using appropriate cell references format (the cells highlighted in grey) 3 2. Please use fill handler to complete the table. E.g. in cell C16, build one formula and generate other formulas to D16 and E16 with fill handler. 4 3. For "Cost of Goods Sold" section (before "COGS Subtotal"), build one formula in cell C19, and generate formulas until E21. Overhead (B21) is 20% (B10) of the labor cost (B20). 5 4. For "COGS Subtotal", build one formula in C22, and generate the formulas to E22. 6 5. Similar requirements for "Selling Expenses" and "Projected Earnings" section. 7 6. Please be noted, for all items under "Cost of Goods Sold", and "Selling Expenses" the cost is per ONE shoe, not per pair. 8 Number of Shoes Quarter Budget 9 Per Pair 2 20% 10 Overhead % of Labor 11 12 13 Sales Volume - #pairs: 14 Selling Price Per Pair: 15 Item 16 Revenue 17 18 Cost of Goods Sold (per one shoe): 19 Materials 20 Direct Labor 21 Overhead 22 COGS Subtotal 23 24 Selling Expense (per one shoe) 25 26 Projected Earnings 27 Low Priced Medium Priced High Priced $ 1,200 180 780 $ 200 $ 360 230 Low Priced Total Medium Priced Total 216000 $ 156,000 $ High Priced Total 82,800 Costs per Shoe $ 46.20 10.28 2 2 8.00 ✓ Comments Share ✓ Sort & Filter Find & Select Sensitivity Add-ins Analyze Data H J K L M

Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter26: Capital Budgeting (capbud)
Section: Chapter Questions
Problem 2R
See similar textbooks
icon
Related questions
Question
Home Insert Draw Page Layout Formulas Data Review View Automate Developer Calibri (Body) 12 ✓ Α Αν Conditional Formatting ✓ ☑Insert v Σ Custom Paste B I U ✓ ✓ $ ✓ %9 0 .00 →0 Format as Table ✓ Cell Styles ▾ Delete ✓ Format ✓ C26 fx A B D E F G 1 Instruction: 2 1. Please complete the following budget plan using appropriate cell references format (the cells highlighted in grey) 3 2. Please use fill handler to complete the table. E.g. in cell C16, build one formula and generate other formulas to D16 and E16 with fill handler. 4 3. For "Cost of Goods Sold" section (before "COGS Subtotal"), build one formula in cell C19, and generate formulas until E21. Overhead (B21) is 20% (B10) of the labor cost (B20). 5 4. For "COGS Subtotal", build one formula in C22, and generate the formulas to E22. 6 5. Similar requirements for "Selling Expenses" and "Projected Earnings" section. 7 6. Please be noted, for all items under "Cost of Goods Sold", and "Selling Expenses" the cost is per ONE shoe, not per pair. 8 Number of Shoes Quarter Budget 9 Per Pair 2 20% 10 Overhead % of Labor 11 12 13 Sales Volume - #pairs: 14 Selling Price Per Pair: 15 Item 16 Revenue 17 18 Cost of Goods Sold (per one shoe): 19 Materials 20 Direct Labor 21 Overhead 22 COGS Subtotal 23 24 Selling Expense (per one shoe) 25 26 Projected Earnings 27 Low Priced Medium Priced High Priced $ 1,200 180 780 $ 200 $ 360 230 Low Priced Total Medium Priced Total 216000 $ 156,000 $ High Priced Total 82,800 Costs per Shoe $ 46.20 10.28 2 2 8.00 ✓ Comments Share ✓ Sort & Filter Find & Select Sensitivity Add-ins Analyze Data H J K L M
Transcribed Image Text:Home Insert Draw Page Layout Formulas Data Review View Automate Developer Calibri (Body) 12 ✓ Α Αν Conditional Formatting ✓ ☑Insert v Σ Custom Paste B I U ✓ ✓ $ ✓ %9 0 .00 →0 Format as Table ✓ Cell Styles ▾ Delete ✓ Format ✓ C26 fx A B D E F G 1 Instruction: 2 1. Please complete the following budget plan using appropriate cell references format (the cells highlighted in grey) 3 2. Please use fill handler to complete the table. E.g. in cell C16, build one formula and generate other formulas to D16 and E16 with fill handler. 4 3. For "Cost of Goods Sold" section (before "COGS Subtotal"), build one formula in cell C19, and generate formulas until E21. Overhead (B21) is 20% (B10) of the labor cost (B20). 5 4. For "COGS Subtotal", build one formula in C22, and generate the formulas to E22. 6 5. Similar requirements for "Selling Expenses" and "Projected Earnings" section. 7 6. Please be noted, for all items under "Cost of Goods Sold", and "Selling Expenses" the cost is per ONE shoe, not per pair. 8 Number of Shoes Quarter Budget 9 Per Pair 2 20% 10 Overhead % of Labor 11 12 13 Sales Volume - #pairs: 14 Selling Price Per Pair: 15 Item 16 Revenue 17 18 Cost of Goods Sold (per one shoe): 19 Materials 20 Direct Labor 21 Overhead 22 COGS Subtotal 23 24 Selling Expense (per one shoe) 25 26 Projected Earnings 27 Low Priced Medium Priced High Priced $ 1,200 180 780 $ 200 $ 360 230 Low Priced Total Medium Priced Total 216000 $ 156,000 $ High Priced Total 82,800 Costs per Shoe $ 46.20 10.28 2 2 8.00 ✓ Comments Share ✓ Sort & Filter Find & Select Sensitivity Add-ins Analyze Data H J K L M
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
SEE MORE TEXTBOOKS