Answered step by step
Verified Expert Solution
Question
1 Approved Answer
solutions in excel above. can you answer 5 & 6 in excel? excel 1.dsk Excel (Product Activation Failed) KHUSHBOO MEHTA HOME INSERT PAGE LAYOUT FORMULAS
solutions in excel above. can you answer 5 & 6 in excel?
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% 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 & Center Format Painter Clear . Font Alignment Cells Editing 449 20 NOV DEC TOTAL 23 PRODUCTION 24 COFFE BEANSREQIFEDPOUNOS 25 Add: 28 Less:Invertory et beg 27 Budooted purchaso in Pound 28 Budgeted purchese in 3 B17 823+C23+D23 dezired at month ond D24"20% :F24, 20% 9845 13500 ROUNDUPIE24+ ROUNDLFE24-825-826,0 5 E277 ROUNDLPIC24-025-C28,05 ROUNDOUPID24+D25-D26.0 27T 0277 NOV CEC 32 33 PRODUCTION BAGS 4 AROLLSREGUFED TOTAL B33+033+D33 -E33100 3.38 IAN 3380 -F3300 633100 C 34.10% C33100 0331100 F34 10 Add: deaired at month ond D34. Less: Invertory et beginning 37 Budooted purchase ROLL FONDLPB:34-835-836,0 5 FONDLPIC 344C 35-C 36.0:ROUNCUPID34+D35-D36,0.51 837+03 'ed purchaser 03T 24 NOV DEC TOTAL 43 PRODUCTION B43+043+043 B45+045+045 E45 E46 4 Labour hours requred 45 TotalLabour hours B43B44 043 044 043 D44 20 Labour costlhour Total budootedlabour cost 47 B45 B46 045 046 045'046 Sheet1 Sheet2 +70%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