I just need the formulas. the first page with the yellow highlight is the data sheet. Even the formulas for the two photos that I already did to make sure I did them right. Thanks in Advanced. Its one question with muli parts, so I will do other questions for the other parts. If one one of the fill in boxes does not need a formula could u please state the caterigory from the data sheet where that number is pulled from.
AutoSave On . ACC202- Excel Budgeting Project Master - Saving.. O Search X . Saint LB MyAcc @ VitalSo C This Is C This Is C AutoSa QU X + File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat C coursehero.com/file/55574220/QUIZ-2-ACC202-Budgeting-Pr... C C WA & Cut Arial 14 ~ A" A E de Wrap Text General Glowforge - the 3D... disney C Home | Chegg.com YouTube Paste [ Copy Apps G Google Format Painter E Merge & Center $ ~ % " 00 20 Formatting Table Styles v Clear v Filter > Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity F9 X Y B E F G H J K M NO P Q R S T U W X I AE AF AG AH AI AJ ACC 202 BUDGETING PROJECT 2 STUDENT NAME: 3 Sales Projections in Units January 14,840 Februar 36,086 March 39,653 April 51,913 May 64,883 Projected Sales Price/Uni $ 232.00 12 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit $5.00 Fixed Cost $5,839 Production: 17 Desired Ending Inventory 14.6% Beginning Inventory (new business) 0 19 20 Materials Desired Ending Inventory 74.0% Number of Materials per Unit 15.0 23 Projected Cost/Material Unit $12.00 Beginning Inventory (new business) 0 26 Direct Labor IN Time per Unit (in hours) 3.00 28 Cost per Hour $14.00 29 30 Manufacturing Overhead 31 Variable Cost/Unit $4.00 Fixed Costs $6,175 Description Data Sheet Sales Budget | Operating Budget | Production Budget Materials Req. Budget | Direct Labor Budget | Manu OH Budget | Prc ... + Ready - - - + 59% Type here to search O f P 9 N 10:04 PM 3/9/2021AutoSave On . ACC202- Excel Budgeting Project Master - Saved O Search X . Saint L B MyAcc B VitalSo C This Is C This Is C AutoSa QU X + File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat C coursehero.com/file/55574220/QUIZ-2-ACC202-Budgeting-Pr... C C WA & Cut Arial 14 A" A ap Wrap Text General [ Copy Apps Glowforge - the 3D... disney C Home | Chegg.com YouTube G Google Paste Format Painter BIU DAY EEE EE E Merge & Center v $ ~ % " .00 0 Formatting Table Styles v Clear v Filter > Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity X V A B C D E F G H J K L M N 2 SALES BUDGET January February March April 3 Projected Sales in Units 14,840.00 36,086.00 39,653.00 51,913.00 Selling Price per Unit 232.00 232.00 232.00 232.00 5 Anticipated Sales Dollars 3,442,880 8,371,952 9, 199,496 12,043,816 6 10 11 12 13 14 15 16 Description | Data Sheet Sales Budget Operating Budget | Production Budget Materials Req. Budget | Direct Labor Budget | Manu OH Budget | Prc ... + Ready + 100% Type here to search O f P 9 N 10:04 PM 3/9/2021AutoSave On . ACC202- Excel Budgeting Project Master - Saved O Search X . Saint LB MyAcc @ VitalSo C This Is C This Is C AutoSa QU X + File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat C coursehero.com/file/55574220/QUIZ-2-ACC202-Budgeting-Pr... C C WA & Cut Arial 16 A" A de Wrap Text General [ Copy Apps Glowforge - the 3D... disney C Home | Chegg.com YouTube G Google Paste Format Painter BEEFE Merge & Center $ ~ % " .00 0 Formatting Table Styles v Clear v Filter > Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity D14 : X V fx A B C D E F G H J K L M N 0 P 2 4 SELLING & ADMINISTRATIVE EXPENSE BUDGET 5 January February March Sales in Units 14,840.00 36,086.00 39,653.00 Variable S&A Rate/Unit $5.00 $5.00 $5.00 Anticipated Variable Costs 74,200 180,430 198,265 8 Fixed S&A Costs $5,839 $5,839 $5,839 Total Anticipated Selling & 80,039 186,269 10 Administrative Costs 204, 104 11 12 13 14 15 16 Description | Data Sheet | Sales Budget Operating Budget Production Budget Materials Req. Budget | Direct Labor Budget | Manu OH Budget | Prc ... + Ready + 100% Type here to search O f 9 N 0:05 PM 3/9/2021AutoSave On . ACC202- Excel Budgeting Project Master - Saved O Search X . Saint LB MyAcc @ VitalSo C This Is C This Is C AutoSa QU X + File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat C coursehero.com/file/55574220/QUIZ-2-ACC202-Budgeting-Pr... C C WA & Cut Arial 16 ~ A" A de Wrap Text General [ Copy Apps Glowforge - the 3D... disney C Home | Chegg.com YouTube G Google Paste Format Painter BIU FLAV EEE ( E Merge & Center v $ ~ % " .00 0 Formatting Table " Styles v Clear v Filter > Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity D11 X V fix A B C D E F G H I J K M N 0 P Q PRODUCTION BUDGET 3 January February March April Sales in Units 14,840.00 36,086.00 39,653.00 Sales + El = Total Needed - BI = Production 5 Desired Ending Inventory Total Units Needed 6 Beginning Inventory 8 Total Production in Units 9 10 11 12 13 14 15 16 Description | Data Sheet | Sales Budget | Operating Budget Production Budget Materials Req. Budget | Direct Labor Budget | Manu OH Budget | Prc ... + Ready + 100% Type here to search O f P 9 N 0:05 PM 3/9/2021AutoSave On . ACC202- Excel Budgeting Project Master - Saved O Search X . Saint L B MyAcc B VitalSo C This Is C This Is C AutoSa QU X + File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat C coursehero.com/file/55574220/QUIZ-2-ACC202-Budgeting-Pr... C C WA & Cut Arial 16 ~ A" A ap Wrap Text Accounting Paste [ Copy Apps Glowforge - the 3D... disney C Home | Chegg.com YouTube G Google Format Painter BIU FDA ~ EEE EE E Merge & Center $ ~ % " .00 0 Formatting Table Styles v Clear Filter > Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity C13 X fx A B C D E F G H J K L M N O P Q 4 MATERIALS REQUIREMENTS BUDGET N January February March April 3 Units to be Produced Material/Unit Total Production Need 6 Desired Ending Inventory Total Materials Needed 8 Beginning Inventory Total Materials Needed to be Purchased 10 Cost per Unit of Material Total Material Cost 11 12 Material/unit 13 14 Cost per Unit of Material 15 Cost of Material per Product Description | Data Sheet | Sales Budget | Operating Budget | Production Budget Materials Req. Budget Direct Labor Budget | Manu OH Budget | Prc ... + Ready + 100% Type here to search O f 9 N 0:05 PM 3/9/2021
