Question: subject name - excel Excel Lab 4 Open a new excel document and save as Budget.is Reproduce the following Sheet do all the calculation with

subject name - excel

Excel Lab 4 Open a new excel document and save as Budget.is Reproduce the following Sheet do all the calculation with excel Format the sheet to look like the originals 1 Note 1: renante ne sheet Year Eles fotal online interes institutions Note 3 Publicity Sales total Note 4 Cost of sales Sales total Box No 5 Charges tetri putety merchandise constataries trentiscelaneous generales Prof. Charges Total IN Profi percentang Profiten total www.Page Break Original D Sales Online Decoration international - 2015 Ja fe Mar Apr May Jun Sep Da 1300 000 $216.000 30000 1210000 50000 50000 3000 2300 $175.000 50 306 300 STE DOOS150.000 1000 210.000.000 36000 30000 120.000.000 RAS Sales 11 Expo 12 telf is 10 Bert 11.com 16 1 x Total Pro 336210 33200 SJ 100 5210 000 $22.000 EXS300 5x20 50 990.000 ES 3. 100 12200 SX N 3.0 10 SU 10 5350 ME 2 345.000 see 56210 EM 323 8888 27 17 Sales On Public Seal Cosoft Sales Espero tal public.com Prolit - Sale Total Expenses Toul : Original 11 Decoration International - 2015 Leb MRE 4 5 Sales ARE MAY Jun Aug Total 5201000 $363000 $135.000 $215.000 $325.000 $200.000 $300 000 $10.000 SZ36.000 52-60 $135 030 $185.000 5J00000 SO 9210030 $175.000 $16000 $145.000 $125,000 $125,000 $165.000 525 000 $250 MG Stec.wo $135 000 $250 000 $35.000 517500 $160.000 5290 300 $245.000 250.000 5510 100 5113 000 $110.000 $200,100 inst Distributors Sales Tutal 10 11 Expenses 12 Unity 11 Out of sales 14 Salaires 15 Rere 15 Tenport 11 Gert 16 19 Expenses Total 20 21 Pub $35,210 $32.000 $33.000 $35.215 $35.000 522.000 336400 335210 528.000 $80,000 500 335,20 525.00 22.000 535210 $24.000 525.00 500 $35219 33400 530.00 $40 100 335210 $42.000 5451 $40 00 336.210 $39.000 40 DOC Sin 100 335210 525.000 $20.000 54515 535.210 523.000 $25.00) $40.00 $35,210 120.000 128.500 546100 396210 $48.000 6.100 $478.400 522.620 77.000 5295000 Protect 24 24 20 27 12 33 47 Sales Total Onine.rs Pitlichy Sales Cost at als Solesal Expenses al picty cost olvasottunut geel cool Prolit - Sales Total. Expenses Total Profit percentage - Pro Salaston Excel Lab 4 Open a new excel document and save as Budget.is Reproduce the following Sheet do all the calculation with excel Format the sheet to look like the originals 1 Note 1: renante ne sheet Year Eles fotal online interes institutions Note 3 Publicity Sales total Note 4 Cost of sales Sales total Box No 5 Charges tetri putety merchandise constataries trentiscelaneous generales Prof. Charges Total IN Profi percentang Profiten total www.Page Break Original D Sales Online Decoration international - 2015 Ja fe Mar Apr May Jun Sep Da 1300 000 $216.000 30000 1210000 50000 50000 3000 2300 $175.000 50 306 300 STE DOOS150.000 1000 210.000.000 36000 30000 120.000.000 RAS Sales 11 Expo 12 telf is 10 Bert 11.com 16 1 x Total Pro 336210 33200 SJ 100 5210 000 $22.000 EXS300 5x20 50 990.000 ES 3. 100 12200 SX N 3.0 10 SU 10 5350 ME 2 345.000 see 56210 EM 323 8888 27 17 Sales On Public Seal Cosoft Sales Espero tal public.com Prolit - Sale Total Expenses Toul : Original 11 Decoration International - 2015 Leb MRE 4 5 Sales ARE MAY Jun Aug Total 5201000 $363000 $135.000 $215.000 $325.000 $200.000 $300 000 $10.000 SZ36.000 52-60 $135 030 $185.000 5J00000 SO 9210030 $175.000 $16000 $145.000 $125,000 $125,000 $165.000 525 000 $250 MG Stec.wo $135 000 $250 000 $35.000 517500 $160.000 5290 300 $245.000 250.000 5510 100 5113 000 $110.000 $200,100 inst Distributors Sales Tutal 10 11 Expenses 12 Unity 11 Out of sales 14 Salaires 15 Rere 15 Tenport 11 Gert 16 19 Expenses Total 20 21 Pub $35,210 $32.000 $33.000 $35.215 $35.000 522.000 336400 335210 528.000 $80,000 500 335,20 525.00 22.000 535210 $24.000 525.00 500 $35219 33400 530.00 $40 100 335210 $42.000 5451 $40 00 336.210 $39.000 40 DOC Sin 100 335210 525.000 $20.000 54515 535.210 523.000 $25.00) $40.00 $35,210 120.000 128.500 546100 396210 $48.000 6.100 $478.400 522.620 77.000 5295000 Protect 24 24 20 27 12 33 47 Sales Total Onine.rs Pitlichy Sales Cost at als Solesal Expenses al picty cost olvasottunut geel cool Prolit - Sales Total. Expenses Total Profit percentage - Pro Salaston

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

ACCT 2281: Accounting Software Systems 1 TRU Open Learning Final Project (25%) The information provided in this test allows you to set up all ledgers for an Ontario company named KILLARNEY...

n I LAN> Labs 1 and 2, which increase in difficulty, require you to create webpages based on what you learned in the chapter; Lab 3 requires you to dive deeper into a topic covered in the chapter....

CIS 3100 - Business Intelligence Case Equal Pay Assessment for Mell Industries, Inc. 1. Project Overview The activities in this project are designed to provide experience performing data analysis...

Business Intelligence Case P r o ject Background Mell Industries is a national manufacturing firm that specializes in textiles based out of Chicago. Starting out as a small factory in Warrenville,...

please answer the last 2 pictures with the data in the beginning. need for this case: 1. Download the Excel file -Discount_Goods_Big_Store_Financials: 2. Open Tableau and connect to the Excel file....

Minimizing Profit Ajax Mobility produces bicycles with three different speeds: three-speed, five-speed, and ten-speed. Each bicycle undergoes a production process that spans three departments:...

PLEASE HELP ME!!!! Minimizing Profit Ajax Mobility produces bicycles with three different speeds: three-speed, five-speed, and ten-speed. Each bicycle undergoes a production process that spans three...

1. Download the Excel file "Inventory." 2. Open Tableau and connect to the Excel file. Click on the "Sheet 1" tab, at the bottom of the canvas, to the right of the Data Source at the bottom of the...

In the prior chapters' Applying Tableaus, you examined two ( hypothetical ) publicly traded companies, GPS Corporation and Tru. Incorporated, as to their pattern of leasing facilities, their...

Summit Builders has a market debt-equity ratio of 0.65 and a corporate tax rate of 40%, and it pays 7% interest on its debt. By what amount does the interest tax shield from its debt lower Summits...

Julian Manufacturing, Inc., wishes to determine the profitability of its products and asks the cost accountant to make a comparative analysis of sales, cost of sales, and distribution costs of each...

2 Suppose you are managing a grocery store and would like to provide a first-rate shopping experience to your customers. Outline how you would go about determining factors that are important to them,...

The HTML 5 _ _ _ _ _ _ _ _ element visually displays a bar that depicts a numeric value within a specified range. section time progress meter