Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

CISA Certified Information Systems Auditor Practice Exams

Authors: Peter H. Gregory

1st Edition

1260459845, 978-1260459845

More Books

Students also viewed these Accounting questions