Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Excel ACC 311 Project Two Workbook Template - View-only Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help

image text in transcribed

Excel ACC 311 Project Two Workbook Template - View-only Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help 12 B A ... ab Ev F10 1 2 3 4 5 6 fx A B Posey's Pet Emporium Posey's Pet Emporium Budget Data Viewing Edit a copy Comments .00 ATV Ov ... C D E F G H I J K 7 Budgeted selling price [Insert value] 8 9 Sales Volume Budgets 10 June [Insert value] 11 122 12 July August [Insert value] [Insert value] 13 September [Insert value] 14 October [Insert value] 15 16 Percentage of Sales 17 Cash sales [Insert value] 18 Credit collected in 19 20 21 Month of sale Following month Uncollectable [Insert value] [Insert value] [Insert value] 22 23 FG (finished goods) inventory goal [Insert value] following month's sales volume > = Budget Data 1 Sales Forecast& Cash Receipts 2 Production & DM Purchases 3 Cash Disbursements Budget 4 COGS 5 + Give Feedback to Microsoft 100% + Excel Workbook Statistics ACC 311 Project Two Workbook Template - View-only Search (Alt+Q) Q File F Home Insert Draw Page Layout Formulas H JI Data A Review View W Help 12 B ab General F27 A fx Viewing ZM Edit a copy zo TV Ov Comments ZC ZR C D E F G H | J K L 14 October [Insert value] 15 16 Percentage of Sales 17 Cash sales [Insert value] 18 Credit collected in 19 20 21 Month of sale Following month Uncollectable [Insert value] [Insert value] [Insert value] 22 23 FG (finished goods) inventory goal [Insert value] 24 Target ending inventory DM (direct materials) [Insert value] 25 Pounds per completed unit of DM [Insert value] 26 Expected cost per pound [Insert value] 27 28 Percentage of Purchase Payments 29 Month of purchase [Insert value] 30 Month after purchase [Insert value] 31 Budgeted purchases - June [Insert value] 32 33 Other cash disbursements per month [Insert value] 34 35 Beginning cash balance - July [Insert value] 36 37 38 39 40 41 following month's sales volume > = Budget Data 1 Sales Forecast& Cash Receipts 2 Production & DM Purchases 3 Cash Disbursements Budget 4 COGS 5 + Excel ACC 311 Project Two Workbook Template - View-only Search (Alt +Q) File Home Insert Draw Page Layout Formulas Data Review View Help Dv 12 B Gv Ax =v ab v General H11 fx A B C D E F G H 1 2 3 4 5 Posey's Pet Emporium July August September Quarter Sales Forecast Budgeted sales 6 volume 7 Budgeted selling price Budgeted sales 8 revenue [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [insert formula] formula] [Insert formula] [insert formula] [Insert formula] [Insert formula] [Inseert 9 Cash Receipts Budget July August September Quarter 10 Beginning A/R (June 11 collections) [Insert formula] 12 July cash sales [Insert formula] July credit sales 13 [Insert formula] [Insert formula] August cash sales 14 [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] August credit sales 15 [Insert formula] [Insert formula] [Insert formula] September cash sales 16 [Insert formula] [Insert formula] 17 September credit sales [Insert formula] [Insert formula] Total cash receipts 18 [Insert formula] [Insert formula] [Insert formula] [Insert formula] 19 Viewing Edit a copy Comments .00 > = Budget Data 1 Sales Forecast& Cash Receipts 2 Production & DM Purchases 3 Cash Disbursements Budget 4 COGS 5+ Workbook Statistics Give Feedback to Microsoft J 100% + Excel ACC 311 Project Two Workbook Template - View-only Search (Alt + Q) File Home Insert A Draw Page Layout H N JI P Formulas M Data Review R View Help W Viewing ZM Edit a copy ZO Comments ZC 5 12 B ab General .00 ) ... - H8 fx B C 1234in 6 Production Budget Budgeted sales volume Add: Target ending FG inventory D E F G Posey's Pet Emporium July August [Insert formula] [Insert formula [Insert formula] [insert formula] September [Insert formula] [insert formula] Quarter [Insert formula] [insert formula]| 6 7 8 Total units needed Less: Beginning FG inventory [Insert formula] [Insert formula] [Insert formula] [Insert formula] Budgeted units to be [Insert formula] [Insert formula] [Insert formula] [Insert formula] 9 produced 10 11 12 DM Purchases Budget July August Budgeted units to be [insert formula] [Insert formula] September [Insert formula] Quarter [Insert formula] 13 produced x Pounds of DM per unit [Insert formula] [Insert formula] [Insert formula] [Insert formula] 14 Total production needs [Insert formula] [Insert formula] [Insert formula] [Insert formula] G 15 (pounds) Add:Target ending DM 16 inventory (pounds) Total DM inventory 17 needs (pounds) [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] Less: Beginning DM [Insert formula] [Insert formula] [Insert formula] [Insert formula] 18 inventory (pounds) Budgeted pounds of DM [Insert formula] [Insert formula] [Insert formula] [Insert formula] 19 to be purchased 20 DM cost per pound [Insert formula] [Insert formula] [Insert formula] [Insert formula] Total budgeted cost of > = Budget Data 1 Sales Forecast& Cash Receipts 2 Production & DM Purchases Workbook Statistics AutoSave Off H H 3 Cash Disbursements Budget 4 COGS 5 ACC 311 Project Two Workbook Template -... Search Data Review View Automate Help + ZR A Give Feedback to Microsoft - 100% + Newsome, Debra ND Comments Share File Home Insert Page Layout Formulas G5 fx [Insert formula] A B C D F F G H 1 -23 4 567 DM Cash Disbursements A/P balance from June* July purchases 8 August purchases September purchases Total DM Cash Disbursements 9 10 Other Cash Disbursements Total Cash 30 1221576222222222222~3 34 Ready Disbursements July Posey's Pet Emporium August September Quarter [Insert formula] [insert value} [Insert formula] [Insert formula] [insert value} [Insert formula] [Insert formula] [Insert formula] [insert value} [insert value} [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] 2 Production & DM Purchases ... 3 Cash Disbursements Budget 4 COGS 5 Cash Budget Accessibility: Investigate B I v 100% Newsome, Debra ND Comments Share E G H | J AutoSave Off ACC 311 Project Two Workbook Template -... Search File Home Insert Page Layout Formulas Data Review View Automate Help E9 fx A B C D 1 2 Posey's Pet Emporium 3 4 Selling price [Insert formula] Less: Target gross margin 5 percentage [Insert formula] 6 Cost of goods sold [Insert formula] 7 Less: DM cost per unit [Insert formula] Additional cost per unit to 8 cover DL and MOH [Insert formula] 9 10 34 PUE6116762222222222222333333 19 20 24 25 Ready ... 2 Production & DM Purchases Accessibility: Investigate 3 Cash Disbursements Budget 4 COGS 5 Cash Budget + 100% AutoSave Off H 2 File Home Insert Page Layout ACC 311 Project Two Workbook Template -... Formulas Search Data Review View Automate Help Newsome, Debra ND Comments Share G7 fx A B 1 2 3 4 Cash Budget 5 Beginning Cash Balance 6 Plus: Cash Receipts 7 Cash Sales 8 Cash Collections 9 Total Cash Receipts 10 Total Cash Available 11 12 Ending Cash Balance Less: Cash Disbursements August [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] C D E F G H I J K Posey's Pet Emporium July September Quarter 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 82 83 34 35 36 37 38 89 40 3 Cash Disbursements Budget 4 COGS 5 Cash Budget + eady Accessibility: Investigate = Type here to search B 100% >>> 4:49 PM W X Desktop 8/3/2023

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Understanding the Data The spreadsheet contains several tables spread across different sheets or sections Each table appears to track financial data over various periods July August September and Quar... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting concepts and applications

Authors: Albrecht Stice, Stice Swain

11th Edition

978-0538750196, 538745487, 538750197, 978-0538745482

More Books

Students explore these related Accounting questions