Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
to better learn these problems can I please get the excel formulas for the calculation for these problem? D16 =0.6 D Projected Budgeting Data 2020
to better learn these problems can I please get the excel formulas for the calculation for these problem?
D16 =0.6 D Projected Budgeting Data 2020 October November December 2021 January February 50.000 $4.75 72.000 $4.75 68,000 $4.75 51,000 $4.75 58.000 $4.75 Assete Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory PP&E.net Big Batch Crisp Co. Balance Sheet As of September 30th, 2020 Liabilities & Equil 225.200 Accounts Payable 87.000 Notes Payable 3,986 Interest Payable 6.925 Total Labs 90,000 Retained Eaming Total Equities 410,11 Total Labs & BOS 40% Total Assets of next month' unt sales unds 2.500 Sales: Sales in Units Gars) 13 Seling PricePerUnitan 5 Collections: Colected in Month of Sale Collected in Month following Sale Finished Goods Inventory Ending FG Inventory Requirement 11 Beginning FG Inventory, October 1, 2020 2 Raw Materials inventory 4 Beginning RM Inventory, October 1, 2020 Raw Materials Required per Unit of FG Raw Materials Cost per Pound 7 Ending RM Inventory Requirement 28 Paid in Month of Purchase Paid in Following Month Direct Labor 12 Labor Required per Unt of FG 13 Labor Couper Hour 14 15 Manufacturing Overhead 36 Variable OH Fed OH 18 Noncash Food OH (included in above) 1.535 0.20 pound pounds par pound of next month's production needs 50% 50% 0.05 $17.00 hours per hour $1.40 $9.000 $6.000 per unit per month per month 30 11 Selling & Administrative Expenses: Variable SSA $0.80 per und ACCT 285 cel Project Template-Fall 2020.xlsx - LibreOffice Calc Ele Et Vorwert Format Styles Sheet Data Tools Window Help XA 6.2. Abla 17 BIU A 9.% 00 700 fx = 6 F G H D B 1 2 Schedule of Expected Cash Collections 4 2020 November December 5 October TOTAL 7 Cash from Current Month Cash from Prior Month TOTAL CASH COLLECTIONS 9 11 12 13 15 12 30 4 Sales Budget o ACCT 285 Excel Project Template-Fall 2020 (2) LibreOffice Cak de [dt View Insert Format Styles Sheet Duta Tools Window Help XI. A 6. Ab T. 1 a. 318 Ariel % 00 7 000 12 BIU A... 5 06 fx. B EF G H 1 2 Production Budget 3 4 2020 2021 5 October November December Total January February Sales in Un Plus Desired Units of Ending Inventory Total Unit Requirements Less Units in Beginning inventory PRODUCTION IN UNITS 70 12 13 15 17 12 25 Besed Cash Collection SE 285 Excel Project Template-Fall 2020 lx - LibreOffice Calc at View Insert Format Styles Sheet Data Tools Window Help Da BA 5:. Ab 19 31 7 E 12 BI U A.. 9.% 00 7 0002 (fx E . B D E G H F Raw Materials Purchases Budget 2020 2021 October November December TOTAL January 6 7 9 Units Produced Pounds of RM Required Per Unit of FG Total Pounds Used in Production Plus Desired Pounds in Ending Inventory Total Pounds Required Less Pounds in Beginning inventory RAW MATERIALS PURCHASES (POUNDS Cosi per Pound RAW MATERIALS PURCHASES COST 11 12 13 V 17 19 neur DL Here 285 Excel Project Template-Fall 2020 (2) LibreOffice Calc View Insert Format Styles Sheet Data Tools Window Help XA 6.7. Aby E. TIL 31 BIE 12 BIUA.. 9 - % 00 7 000 fx >= D E 1 f G H Direct Labor Budget . 5 TOTAL 6 7 8 2020 October November December Units Produced Labor Hours per Unit TOTAL LABOR HOURS REQUIRED Rate per Labor Hour TOTAL DIRECT LABOR COST 9 11 92 11 14 15 33 SAAB ACCT 2015 Excel Project Template-Fall 2020 (2) - LibreOffice Calc Ele Edit yiew met Format Styles Sheet Data Tools Window Help DBX XA 6. Ab 137 Real 17. % 00 7.00 fx. D E F G BIUA. E=35 H 1 B 1 2 Manufacturing Overhead Budget TOTAL 3 4 2020 October November December 6 Units Produced 7 Nariable Overhead Rate per Unit 8 Total Variable Overhead Cost 9 Fued Overhead 9 TOTAL OVERHEAD COST 11 Nash Overhead Expenses 12 TOTAL OVERHEAD DISBURSEMENTS 14 . ACCT 25 Excel Project Template-Fall 2020 x LibreOffice Cake File Edit you not Format Styles Sheet Data Tools Window Help XBMA 5.2. Abs al BIUAE fx. D E 1. Na ? % 00 Z CS H 1 F A 1 2 Selling & Administrative Expense Budget 3 4 TOTAL 8 9 10 2020 October November December Unit Sales Variable S&A per Unit Total Variable SRA Fixed SEA TOTAL S8A EXPENSE Nonach S&A Expenses TOTAL SRA DISBURSEMENTS 11 12 13 4 15 16 17 99 21 Putin Buda O ty 0 ACCT 2015 Excel Project Template-Fall 2000 (2) - LibreOffice Calc File Edt View met gemat Styles Sheet Data Tools Window Help XOA 5.2. Ab tu aj 317 Anal BIU A ... % 00 17 00 02 H26 G D A 2 Cash Budget 3 2020 November December 5 October QUARTER 6 7 8 10 11 72 Beginning Cash Balance Cash Collections Available Cash Balance Cash Disbursements Dired Material Pro Direct Material Current Direct labos Overhead SEA Equipment Purchase Nolie Payme Interest Total Cash Disbursements ENDING CASH BALANCE 14 15 45 2 ON Buyet ACCT 205 Excel Project Template-Fall 2000 (2) - LibreOffice Calc Ele foit View Insert Format Styles Sheet Data Tools Window Help a XAS. Ab .. aj 317 12 BIUA... % 00 70 fx = 8 C D E G 2 1 H F 1 2 3 5 6 7 8 Freddie's Fresh Fruit Company Budgeted Income Statement For the Quarter Ending December 31, 2020 Sales Variable Expenses: Variable Manufacturing Expense Variable S&A Expense Contribution margin Fixed Expenses: Fixed Manufacturing Expense Fixed SA Expense Net Operating Income Interest Expense Net Income 11 7 15 17 70 ACCT 285 Excel Project Template Fall 2020 (2) LibreOffice Calc Ele Et View Insert Format Styles Sheet Data Tools Window Help XA56. Abs. 1 a 317 Real 12 BIUA.. % 00 7 04.025 fx. D G 119 E 1 2 4 Freddie's Fresh Fruit Co. Budgeted Balance Sheet As of December 31, 2020 LIABILITIES & EQUITIES Accounts Payable Notes Payable Interest Payable TOTAL LIABILITIES ASSETS Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory PP&E, vt T 8 11 12 Retained Earnings TOTAL EQUITIES TOTAL LIABILITIES & EQUITIES TOTAL ASSETS 15 11 9 22 mory Card Cash Com O heel O
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c513502ad6_436669c513463f2f.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c5135d100c_437669c513533358.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c5136ac914_438669c5136087b8.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c51379d013_439669c5137036c6.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c51388f1d4_439669c5137ecabd.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c51398045d_440669c5138ce8a0.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c513a6668b_441669c5139be638.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c513b606d9_442669c513aad1b9.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c513c508e0_443669c513ba3831.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c513d4bf41_444669c513caaa55.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started