Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you answer 7 & 8 on excel & show work? thanks. solutions 1-4 solutions 5-6 https://www.chegg.com/homework-help/questions-and-answers/excel-1dsk-excel-product-activation-failed-khushboo-mehta-home-insert-page-layout-formulas-q36952984 Questions needed: excel 1.dsk Excel (Product Activation Failed)
Can you answer 7 & 8 on excel & show work? thanks.
solutions 1-4
solutions 5-6 https://www.chegg.com/homework-help/questions-and-answers/excel-1dsk-excel-product-activation-failed-khushboo-mehta-home-insert-page-layout-formulas-q36952984
Questions needed:
excel 1.dsk Excel (Product Activation Failed) KHUSHBOO MEHTA HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW S Cut E Copy Calibri Fill Paste Conditional Format as Cell Insert Delete Format Formatting TableStyles Sort &Find& Filter Select Format Painter .Clear Font Alignment Cells Editing L39 October November December Tota -SUM(B3:D3 19.5 -E3 E4 ANUARY FEBRUARY 3 Sales (Bags 4 Price per Bag S 5 Total Revenue S 55000-8%. 55000 19.5 -83 84 0000 8% 90000 19.5 -03-0 60000-8%" 19.5 G3 G4 19.5 19.5 -F3 F4 7 Cash 8 Credit I"35% :D5"35% E5.35 -85.65% -G"65% 05.65% -E5. 6596 10 12 October December -03 November 14 Sales 15 Add: inve 16 Less: I 17 Production -G3 uired at end ofmonth rC14. 10% D14+10% 5940 C14 C15-C16 75000+75000+8%-10% 9720 -014+D15-D16 8100 5350 -E14+E15-E16 :G14. 10% 8100 F14+F15-F16 available at the inning of mor5350 -814+815-816 19 20 OCTOBER TOTAL Nov C17 C23 1.25 D24"20% DEC 017 -D23 1 25 AN 23 PRODUCTION 24 COFFE BEANS REQUIRED POUNDS 25 Add: I -823 1 25 -C24.20% 823+C23+D23 -824+C24+D24 9845 F23-1 25 desired at month end 24.20% Sheet1 Sheet2 +85% 5. GBCoffee budgets indirect materials (e.g., water used in the pre-wash phase) at S0.10 per bag. GSO treats indirect labor and utilities as mix ed costs. The variable components are $0.50 per bag for indirect labor and S0.20 per bag for utilities. The following fixed costs per month are budgeted for in direct labor, $26,500, utilities, $16,000, and other, $41,500. Prepare a Manufacturing Overhead budget. Variable selling and adm inistrative expenses are $1.20 per bag of coffee sold. Fixed selling and administrative expenses are $60,000 per month. These costs are not itemized, i.e, the budget has only two lineitems- variable operating expenses and fixed operating expenses. Prepare an Operating Expen ses budget. 6
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started