to better learn these materials can I please get the excel calculations on these problems?

can I please get those questions, and please attache the excel calculations for me to better understand the material, the first 2 pictures are the input and the last couple picture are what I am looking for if you have any other questions please let me know

thank you

B C H D E Projected Budgeting Data 2020 October November 2021 January February December 50,000 $4.75 72,000 $4.75 68,000 $4.75 51,000 $4.75 58,000 $4.75 Sales: Sales in Units (jars) Selling Price Per Unit (jar) Collections: Collected in Month of Sale Collected in Month following Sale 60% 40% 5% 2,500 of next month's unit sales units Finished Goods Inventory: Ending FG Inventory Requirement Beginning FG Inventory, October 1, 2020 Raw Materials Inventory: Beginning RM Inventory, October 1, 2020 Raw Materials Required per Unit of FG Raw Materials Cost per Pound Ending RM Inventory Requirement Paid in Month of Purchase Paid in Following Month Direct Labor: Labor Required per Unit of FG Labor Cost per Hour Manufacturing Overhead: Variable OH Fixed OH Noncash Fixed OH (included in above) 1,533 0.20 $2.60 15% 50% 50% pounds pounds per pound of next month's production needs 0.05 $17.00 hours per hour $1.40 $9,000 $6,000 per unit per month per month Selling & Administrative Expenses: Variable S&A Fixed S&A Noncash Fixed S&A (included in above) $0.80 $8,000 $4,500 per unit sold per month per month Cash Borrowing: Interest Payment Note $625 $150,000 per month repayment made Dec. 31, 2020 Other: Equipment Purchase $65,000 purchased Oct. 1, 2020 t Template - Fall 2020 (1) Insert v 2C ber Delete Format Sor Filt v % 9 Conditional Format Cell Formatting as Table Styles o N K M ary 00 75 Assets Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory PP&E, net Big Batch Crisp Co. Balance Sheet As of September 30th, 2020 Liabilities & Equities 225,200 Accounts Payable 87,000 Notes Payable 3,986 Interest Payable 6,925 Total Liabilities 96,000 Retained Eamings Total Equities 419,111 Total Liabilities & Equities 13.840 150,000 0 163,840 255,271 255,271 419,111 Total Assets Arial % 12 BI U AR fx 06 A B D G 1 2 Direct Labor Budget 3 4 5 TOTAL 6 7 8 9 2020 October November December Units Produced abor Hours per Unit TOTAL LABOR HOURS REQUIRED Rate per Labor Hour TOTAL DIRECT LABOR COST 10 11 12 13 14 15 16 17 18 19 20 21 23 24 27 23 30 31 30 INPUTS Glory Coupe Unit Sales Budget RM Budget DL Expected Cash Collections Production Budget Page DL Budget BI Type here to search File Edit View Insert Format Styles Sheet Data Tools Window Help D X BA 5 Abs Arial 12 BIUA...* fx . 0% O C6 C B D G H 1 2 Manufacturing Overhead Budget TOTAL 3 4 2020 5 October November December 6 Units Produced 7 Variable Overhead Rate per Unit 2 Total Variable Overhead Cost 9 Fixed Overhead 10 TOTAL OVERHEAD COST 11 Noncash Overhead Expenses 12 TOTAL OVERHEAD DISBURSEMENTS 1 15 16 17 18 19 20 21 22 24 25 20 NPUTS Frey Case Un Expected Cath Collection Production Budget POH Ouder Type here to search o I N G File Edit View Insert Format Styles Sheet Data Tools Window Help Q XOA 5. Ab E Arial 12 BIUA. fx = B D O % 0 G H A 1 2 Selling & Administrative Expense Budget 3 4 5 TOTAL 6 7 8 9 2020 October November December Unit Sales Variable S&A per Unit Total Variable S&A Fixed S&A TOTAL S&A EXPENSE Noocash S&A Expenses TOTAL S&A DISBURSEMENTS 10 11 13 10 15 15 19 20 23 24 26 ZT 13 16 y Center Unit Salan turtya Expected Cash Collection Preston Budget DLR E O BRE ACCT 285 Excel Project Template - Fall 2020 (3) axlsx - LibreOffice Calc File Edit View Insert Format Styles Sheet Data Tools Window Help XAS.. Abs. 1 a 31 12 BI U AF0% 00 7 H26 fx >= Dual D 1 2 Cash Budget 3 5 2020 November December October QUARTER B 9 10 11 12 13 Beginning Cash Balance Cash Collections Available Cash Balance Cash Disbursements: Direct Material Prior Direct Material Current Direct labor Overhead S&A Equipment Purchase Note Payment nterest Total Cash Disbursements ENDING CASH BALANCE 14 15 17 78 19 20 21 22 23 31 UPUTS FG Com per un Sales Cupected Coach Collections Production AMB Budget Oh w Type Here to send ACCT 235 Excel Project Template-Fall 2020 (3).xlsx - LibreOffice Calc Edit View Insert Format Styles Sheet Data Tools Window Help X ASAb E. t 91 31 B 12 BIU A 350 % 00 Z09.0Q= 119 fx E D E G A B 1 2 4 5 Freddie's Fresh Fruit Co. Budgeted Balance Sheet As of December 31, 2020 LIABILITIES & EQUITIES Accounts Payable Notes Payable Interest Payable TOTAL LIABILITIES 6 ASSETS Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory PP&E, net 7 8 9 10 11 12 13 Retained Earnings TOTAL EQUITIES TOTAL LIABILITIES & EQUITIES TOTAL ASSETS 14 15 16 18 15 21 22 24 25 27 20 M Pred DL Sales + OH Budget Glendar Cound Type here to search O D16 fx =0.6 AB C H 7 E Projected Budgeting Data 2020 October November 2021 January February December Sales: Sales in Units (ars) Selling Price Per Unit (ar) 50,000 $4.75 72.000 $4.75 68,000 $4.75 51,000 $4.75 58,000 $4.75 B 3 10 11 12 13 14 15 16 17 18 19 20 60% 40% 5% 2,500 of next month's unit sales units 24 25 26 27 28 29 10 11 12 pounds pounds per pound of next month's production needs Collections: Collected in Month of Sale Collected in Month following Sale Finished Goods Inventory: Ending FG Inventory Requirement Beginning FG Inventory, October 1, 2020 Raw Materials Inventory: Beginning RM Inventory, October 1, 2020 Raw Materials Required per Unit of FG Raw Materials Cost per Pound Ending RM Inventory Requirement Paid in Month of Purchase Paid in Following Month Direct Labor: Labor Required per Unit of FG Labor Cost per Hour Manufacturing Overhead: Variable OH Fixed OH Noncash Fixed OH (included in above) Selling & Administrative Expenses: 1,533 0.20 $2.60 15% 50% 50% hours 0.05 $17.00 per hour 14 15 16 7 18 19 10 11 $1.40 $9,000 $6,000 per unit per month per month Varahla SRA SORO ner unire ary 00 75 13,840 150,000 Assets Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory PP&E, net Big Batch Crisp Co. Balance Sheet As of September 30th, 2020 Liabilities & Equities 225,200 Accounts Payable 87,000 Notes Payable 3,986 Interest Payable 6,925 Total Liabilities 96,000 Retained Eamings Total Equities 419,111 Total Liabilities & Equities 163,840 255,271 255,271 419,111 Total Assets ACCT 285 Excel Project Template-Fall 2020 (3).xlsx - LibreOffice Calc Edit View Insert Format Styles Sheet Data Tools Window Help X AS: Ab Et 318 Arial 12 BIU A **06.% 00 700.00 119 fx = B D E G 1 2 4 5 Freddie's Fresh Fruit Co. Budgeted Balance Sheet As of December 31, 2020 LIABILITIES & EQUITIES Accounts Payable Notes Payable Interest Payable TOTAL LIABILITIES 6 ASSETS Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory PP&E, net 7 8 10 11 12 13 Retained Earnings TOTAL EQUITIES TOTAL LIABILITIES & EQUITIES TOTAL ASSETS 14 15 16 17 18 14 23 22 24 25 27 11 MB Sales DL Po nedary Cound CHEurya Type here to search O ACCT 285 Excel Project Template-Fall 2020 (3).xlsx - LibreOffice Calc File Edit View Insert Format Styles Sheet Data Tools Window Help XAS.. Abs 2 1 1 & Z Aral 12 BIUA *% 00 7 H26 A B D 1 2 Cash Budget 3 4 5 2020 November December October QUARTER 7 B 9 10 11 12 Beginning Cash Balance Cash Collections Available Cash Balance Cash Disbursements Direct Material Prior Direct Material Current Direct labor Overhead ISRA Equipment Purchase Note Payment Interest Total Cash Disbursements ENDING CASH BALANCE 14 15 17 78 19 20 2 22 23 PUTS FG Compound Expected Cash Collections RM Del Oh w Type bere to search O tua File Edit View Insert Format Styles Sheet Data Tools Window Help Q XOA 5. Ab E Arial 12 BIUA. fx = B D 6. % 0 A 1 2 Selling & Administrative Expense Budget 3 4 5 TOTAL 6 7 8 9 2020 October November December Unit Sales Variable S&A per Unit Total Variable S&A Fixed S&A TOTAL S&A EXPENSE Nocash S&A Expenses TOTAL S&A DISBURSEMENTS 10 11 13 14 15 16 19 20 23 24 26 OUTS Ty Center Unit Salan turtya Expected Cash Collection Prin Budget AM Baget DLR File Edit View Insert Format Styles Sheet Data Tools Window Help D X BA 5 Abs Arial 12 BIU A C6 fx .= B C C%C D G H 1 2 Manufacturing Overhead Budget TOTAL 3 2020 5 October November December 6 Units Produced 7 Variable Overhead Rate per Unit 2 Total Variable Overhead Cost 9 Fixed Overhead 10 TOTAL OVERHEAD COST 11 Noncash Overhead Expenses 12 TOTAL OVERHEAD DISBURSEMENTS 10 14 16 17 18 19 20 22 24 25 19 40 INPUTS Gran Castle Und Sh Expected Cash Collections Pradan Guaragat tyle OH Ouder Type here to search O File Edit View Insert Format Styles Sheet Data Tools Window Help D X BA 5 Abs Arial 12 BIU A C6 fx .= B C C%C D G H 1 2 Manufacturing Overhead Budget TOTAL 3 2020 5 October November December 6 Units Produced 7 Variable Overhead Rate per Unit 2 Total Variable Overhead Cost 9 Fixed Overhead 10 TOTAL OVERHEAD COST 11 Noncash Overhead Expenses 12 TOTAL OVERHEAD DISBURSEMENTS 10 14 16 17 18 19 20 22 24 25 19 40 INPUTS Gran Castle Und Sh Expected Cash Collections Pradan Guaragat tyle OH Ouder Type here to search O Arial % 12BI U AR fx E 06 B D G 1 2. Direct Labor Budget 3 4 5 TOTAL 6 7 8 9 2020 October November December Units Produced Labor Hours per Unit TOTAL LABOR HOURS REQUIRED Rate per Labor Hour TOTAL DIRECT LABOR COST 10 11 12 13 14 15 16 17 VB 19 20 21 23 30 31 32 30 INPUTS Glory Coupe Unit Sales Gudiyat RM Sudget DL Expected Cash Collections Production Budget Page DL Budget BI Type here to search O ACCT 235 Excel Project Template-Fall 2020 (2) sx - LibreOffice Calc File Edit View Insert Format Styles Sheet Duta Tools Window Help a XA Soa. Abs Et al 31 12 BIUA. - % 00 7 04 OG fx - D E G H A 8 2 Sales Budget 3 4 2020 November December 5 October TOTAL 6 1 Unit Sales Selling Price per Unit TOTAL SALES 8 9 10 12 13 95 18 19 20 25 11 4 OUTS Tory Card RM Budget BL Blue Ce o