Question: How do you calculate the total operating expenses and net income? January February March April May June July August September October November December Total 7112

How do you calculate the total operating expenses and net income?

January February March April May June July August September October November December Total 7112
Income
Sales 120000 123000 126000 129000 132000 135000 138000 141000 144000 147000 150000 153000
Total Income 120000 123000 126000 129000 132000 135000 138000 141000 144000 147000 150000 153000
Cost of Goods Sold
Purchases -60900 -62400 -63900 -65400 -66900 -68400 -69900 -71400 -72900 -74400 -75900 -76500
Commissions -12000 -12300 -12600 -12900 -13200 -13500 -13800 -14100 -14400 -14700 -15000 -15300
Total Cost of Goods Sold -72900 -74700 -76500 -78300 -80100 -81900 -83700 -85500 -87300 -89100 -90900 -91800
Gross Profit 47100 48300 49500 50700 51900 53100 54300 55500 56700 57900 59100 61200
Operating Expenses
Payroll -16000 -16000 -16000 -16000 -16000 -16000 -16000 -16000 -16000 -16000 -16000 -16000
Utilities -7000 -7000 -7000 -7000 -7000 -7000 -7000 -7000 -7000 -7000 -7000 -7000
Other -195000 -195000 -195000 -195000 -195000 -195000 -195000 -195000 -195000 -195000 -195000 -195000
Total Operating Expenses
Net Income

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!

Q:

Repeat Problem 2 using the data below for Kroger Co (NYSE: KR). However, this time you should create a copy of your worksheet to use as a template. Replace the data for Oracle with that of Kroger. a....

Q:

The spreadsheet shows a CHASE strategy for a single product company's production plan over the next 12 months. THERE ARE TWO PARTS TO THIS: FIRST - Construct a spreadsheet that INSTEAD uses a LEVEL...

Q:

Esquire Products Inc. expects the following monthly sales: January $ 45,000 July $ 39,000 February 36,000 August 43,000 March 29,000 September 46,000 April 31,000 October 51,000 May 25,000 November...

Q:

PQR Corporation forecasted its total funding requirements for the coming year as shown in the table below : (ii) Month (iii) January February March April May July August September October November...

Q:

The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room...

Q:

my trial balance is a couple of hundred off can someone help to fix it thanks File Home Insert Draw Page Layout Formulas Data Review View Automate Help 9 Calibri 11 B O A 20 General A27 fs Net Vat B...

Q:

1. June July August September October November December Budgeted total car sales 8,280 5,040 5,230 6,060 5,110 7,060 7,430 Each car is sold at $25,000. 20% of sales during the month are paid in cash...

Q:

Mary Ellis owns a small manufacturing company and would like to develop more accurate estimates for overhead expenses when making planning decisions. She is pretty sure that overhead is a mixed cost...

Q:

The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room...

Q:

Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the flem for parts of 2021 and 2022: May...

Q:

CASH BUDGETING Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016...

Q:

Company ABC specializing in video conferencing. Explain ABC stock volatility history of approximately 81% for a 6-month period. ABC, In October 2019 the stock price was $70 then October 2020 the...

Q:

The circuit shown below is made using identical bulbs and an ideal battery. Which of the following statements is correct? O Bulb D is brighter than bulb F. O Bulb D is dimmer than bulb F. O Bulbs D...

Q:

Value the Credit Agreement, why is it part of the deal? Why is Penny Warrant are included in the agreement, what's their value

Q:

Show Me How Calautator Print tem Double-Dedlining Balance Depreciation A building atquired at the beginning of the year at a cost of $64,000 has an estimated residual value of $2,600 and an estimated...