Pelotoni Dips Inc. manufactures a single product that has become very popular in the Windsor area.  The income statement for the most recent three months prior to taxes are as follows: Pelotini Dips Inc. Income Statement Quarterly Statement ending March 31, 2021             Q1 Q2 Q3 Q4 Sales in Units 4,400 4,000 5,000 4,600           Sales Revenues  $440,000  $400,000  $500,000  $460,000 Less:COGS  $264,000  $240,000  $300,000  $276,000 Gross Margin  $176,000  $160,000  $200,000  $184,000 Less: Expenses         Advertising  $  21,000  $  21,000  $  21,000  $  21,000 Shipping   $  35,000  $  34,000  $  38,000  $  36,000 Salaries and Commissions  $  83,000  $  78,000  $  90,000  $  85,000 Insurance  $    6,000  $    6,000  $    6,000  $    6,000 Depreciation  $  15,000  $  15,000  $  15,000  $  15,000 Total Operating Expenses  $160,000  $154,000  $170,000  $163,000           Net Income (before taxes)  $  16,000  $    6,000  $  30,000  $  21,000     Using the high-low method, separate each mixed expense into variable and fixed expenses.  Provide the cost formula for each mixed expense. [Hint: identify your expenses to find out the mixed expenses.]  Round values to 2 decimal places

SWFT Essntl Tax Individ/Bus Entities 2020
23rd Edition
ISBN:9780357391266
Author:Nellen
Publisher:Nellen
Chapter3: Taxes On The Financial Statements
Section: Chapter Questions
Problem 22P
icon
Related questions
Question

Pelotoni Dips Inc. manufactures a single product that has become very popular in the Windsor area.  The income statement for the most recent three months prior to taxes are as follows:

Pelotini Dips Inc.
Income Statement
Quarterly Statement ending March 31, 2021
         
  Q1 Q2 Q3 Q4
Sales in Units 4,400 4,000 5,000 4,600
         
Sales Revenues  $440,000  $400,000  $500,000  $460,000
Less:COGS  $264,000  $240,000  $300,000  $276,000
Gross Margin  $176,000  $160,000  $200,000  $184,000
Less: Expenses        
Advertising  $  21,000  $  21,000  $  21,000  $  21,000
Shipping   $  35,000  $  34,000  $  38,000  $  36,000
Salaries and Commissions  $  83,000  $  78,000  $  90,000  $  85,000
Insurance  $    6,000  $    6,000  $    6,000  $    6,000
Depreciation  $  15,000  $  15,000  $  15,000  $  15,000
Total Operating Expenses  $160,000  $154,000  $170,000  $163,000
         
Net Income (before taxes)  $  16,000  $    6,000  $  30,000  $  21,000

 

 

  1. Using the high-low method, separate each mixed expense into variable and fixed expenses.  Provide the cost formula for each mixed expense. [Hint: identify your expenses to find out the mixed expenses.]  Round values to 2 decimal places
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
SWFT Essntl Tax Individ/Bus Entities 2020
SWFT Essntl Tax Individ/Bus Entities 2020
Accounting
ISBN:
9780357391266
Author:
Nellen
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning