Homework Help is Here – Start Your Trial Now!
Business
Accounting
Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas: Cost Cost Formula Cost of good sold Advertising expense $30 per unit sold $186,000 per quarter 8% of sales Sales commissions Shipping expense Administrative salaries $98.000 per quarter $10,600 per quarter $66,000 per quarter Insurance expense Depreciation expense Management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. Units sold and the related shipping expense over the last eight quarters follow: Shipping Expense Quarter Units Sold Year 1 First 32.000 $176,000 $191,000 $233,000 $196,000 Second Third 34,000 39,000 35,000 Fourth Year 2 First 33.000 $186,000 $201,000 $248.000 Second 36,000 46,400 43,400 Third $224,000 Fourth Milden Company's president would like a cost formula derived for shipping expense so that a budgeted contribution format income statement can be prepared for the next quarter. Required: 1. Using the high-low method, estimate a cost fomula for shipping expense based on the data for the last eight quarters above. Shipping Units Sold Expense High activity level Low activity level Change Variable cost per unit per unit Fixed cost element Y= X

Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas: Cost Cost Formula Cost of good sold Advertising expense $30 per unit sold $186,000 per quarter 8% of sales Sales commissions Shipping expense Administrative salaries $98.000 per quarter $10,600 per quarter $66,000 per quarter Insurance expense Depreciation expense Management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. Units sold and the related shipping expense over the last eight quarters follow: Shipping Expense Quarter Units Sold Year 1 First 32.000 $176,000 $191,000 $233,000 $196,000 Second Third 34,000 39,000 35,000 Fourth Year 2 First 33.000 $186,000 $201,000 $248.000 Second 36,000 46,400 43,400 Third $224,000 Fourth Milden Company's president would like a cost formula derived for shipping expense so that a budgeted contribution format income statement can be prepared for the next quarter. Required: 1. Using the high-low method, estimate a cost fomula for shipping expense based on the data for the last eight quarters above. Shipping Units Sold Expense High activity level Low activity level Change Variable cost per unit per unit Fixed cost element Y= X

Principles of Accounting Volume 2
Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter3: Cost-volume-profit Analysis
Section: Chapter Questions
Problem 4PB: West Island distributes a single product. The companys sales and expenses for the month of June are...
See similar textbooks
icon
Related questions
Question

Page 1 of 2

Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas: Cost Cost Formula Cost of good sold Advertising expense $30 per unit sold $186,000 per quarter 8% of sales Sales commissions Shipping expense Administrative salaries $98.000 per quarter $10,600 per quarter $66,000 per quarter Insurance expense Depreciation expense Management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. Units sold and the related shipping expense over the last eight quarters follow: Shipping Expense Quarter Units Sold Year 1 First 32.000 $176,000 $191,000 $233,000 $196,000 Second Third 34,000 39,000 35,000 Fourth Year 2 First 33.000 $186,000 $201,000 $248.000 Second 36,000 46,400 43,400 Third $224,000 Fourth Milden Company's president would like a cost formula derived for shipping expense so that a budgeted contribution format income statement can be prepared for the next quarter. Required: 1. Using the high-low method, estimate a cost fomula for shipping expense based on the data for the last eight quarters above. Shipping Units Sold Expense High activity level Low activity level Change Variable cost per unit per unit Fixed cost element Y= X
Transcribed Image Text:Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas: Cost Cost Formula Cost of good sold Advertising expense $30 per unit sold $186,000 per quarter 8% of sales Sales commissions Shipping expense Administrative salaries $98.000 per quarter $10,600 per quarter $66,000 per quarter Insurance expense Depreciation expense Management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. Units sold and the related shipping expense over the last eight quarters follow: Shipping Expense Quarter Units Sold Year 1 First 32.000 $176,000 $191,000 $233,000 $196,000 Second Third 34,000 39,000 35,000 Fourth Year 2 First 33.000 $186,000 $201,000 $248.000 Second 36,000 46,400 43,400 Third $224,000 Fourth Milden Company's president would like a cost formula derived for shipping expense so that a budgeted contribution format income statement can be prepared for the next quarter. Required: 1. Using the high-low method, estimate a cost fomula for shipping expense based on the data for the last eight quarters above. Shipping Units Sold Expense High activity level Low activity level Change Variable cost per unit per unit Fixed cost element Y= X
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Basic Accounting Terms
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
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS