Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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:

image text in transcribed

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

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

Message Brand And Dollars Auditing Marketing Operations

Authors: J. Mike Jacka, Peter R. Scott

1st Edition

163454000X, 9781634540001

More Books

Students also viewed these Accounting questions