Question

In: Accounting

Using the data below for the Ace Guitar Company: A Region B Region Sales $955,500 $514,500...

  1. Using the data below for the Ace Guitar Company:

    A Region B Region
    Sales $955,500 $514,500
    Cost of goods sold 363,100 195,500
    Selling expenses 229,300 123,500
    Service department expenses
    Purchasing $247,000
    Payroll accounting 164,600

    Allocate service department expenses proportional to the sales of each region. Determine the divisional income from operations for the A and B regions. For interim calculations, round percentages to one decimal place.

    A Region $
    B Region $

Solutions

Expert Solution

Answer)

Calculation of Divisional Income

A Region (In $)

B Region (In $)

Sales

                    955,500

                  514,500

Less: Cost of goods sold

                    363,100

                  195,500

Gross Profit

                    592,400

                  319,000

Less: Selling Expenses

                    229,300

                  123,500

Less: Service department expenses

Purchasing

                    160,550

                     86,450

Payroll accounting

                    106,990

                     57,610

Net Divisional Income

                       95,560

                     51,440

Working Note:

Calculation of proportion of sales of each region in total sales

A region = $ 955,500/ ($ 955,500 + $ 514,500)

                 = 65%

A region = $ 514,500/ ($ 955,500 + $ 514,500)

                 = 35%

Allocation of purchasing department expenses:

A Region = $ 247,000 X 65%

                 = $ 160,550

B Region = $ 247,000 X 35%

                 = $ 86,450

Allocation of payroll accounting department expenses:

A Region = $ 164,600 X 65%

                 = $ 106,990

B Region = $ 164,600 X 35%

                 = $ 57,610


Related Solutions

Using the below data, compare the average salary in 1999-2000 by region to 2014-15 by region....
Using the below data, compare the average salary in 1999-2000 by region to 2014-15 by region. Which groups had statistically significant increases? Decreases? Please use excel to solve and show the steps.   Average Salary by Region: Northeast South Midwest West 1999-00 45,312 39,424 38,188 38,604 2014-15 65,559 54,998 52,666 54,440
Company A and Company B are competitors. Using the data provided below, explain which stock is...
Company A and Company B are competitors. Using the data provided below, explain which stock is more attractively valued. Show your calculations to earn full credit. Data Company A Company B Stock price ($) 323.22 89.07 Share outstanding 567,885,369 776,367,881 Earnings per share ($, last year) 12.04 3.71 Earnings per share ($, forward estimate) 18.12 5.58 EBITDA ($billion, last year) 12.4 6.55 EBITDA ($billion, forward estimate) 15.8 8.79 Total debt ($billion) 11.88 11.14 Minority interest ($billion) 0.08 0.00 Cash &...
The following data represent the 2019 monthly sales in units for the Pacific Region Sales Team...
The following data represent the 2019 monthly sales in units for the Pacific Region Sales Team of QualCase, Inc. Month Units sold (xi) (x – x-bar) Squared values Divide total by n-1 SQRT Jan 73 | | Feb 79 | | Mar 76 | | Apr 79 | | May 80 | | Jun 78 | | Jul 77 | | Aug 78 | | Sep 75 | | Oct 72 | | Nov 75 | | Dec 82 V...
Consider the following hypotheses and sample​ data, and then complete parts a and b below using...
Consider the following hypotheses and sample​ data, and then complete parts a and b below using alpha quals=0.10 H0​: μ≤16 H1​: μ>16 19 20 12 19 20 22 14 22 18 17         ​a) What conclusion should be​ drawn? Determine the critical​ value(s). The critical​ value(s) is(are) ______ ​(Round to three decimal places as needed. Use a comma to separate answers as​ needed.) Determine the test​ statistic, _____ ​(Round to two decimal places as​ needed.) What conclusion should be​ drawn?...
the balance sheet for the serden company is shown below for sales of $300000. using the...
the balance sheet for the serden company is shown below for sales of $300000. using the percentage of sales method, assuming no long-term debt is paid off how much outside financing is required?(assume net profit to sales is 6 percent, payout ratio is 60 percent of net income, and sales increase 40 percent during 2019). serden company balance sheet as of Dec. 31, 2018 cash    $15,000 accounts receivable    $60,000 inventory $90,000 current assets $165,000 fixed assets $30,000 total...
Sales Budget XYZ Company 2018 sales forecast is as follows: Quarter 1: 7,000 Product Ace units....
Sales Budget XYZ Company 2018 sales forecast is as follows: Quarter 1: 7,000 Product Ace units. Quarter 2: 9,000 Product Ace units. Quarter 3: 10,000 Product Ace units. Quarter 4: 12,000 Product Ace units Each unit sells for $60 Production Budget The January 1, 2018 beginning inventory of Product Ace is 4,000 units. Management desires an ending inventory each quarter equal to 30% of the next Quarter's sales. Sales in the first and second quarter of 2019 are expected to...
The data below is the data of Promotion and Sales of PT.Duta Pratama. Sales (Y) Promotion...
The data below is the data of Promotion and Sales of PT.Duta Pratama. Sales (Y) Promotion (X) 64 20 61 16 84 34 70 23 88 27 92 32 72 18 77 22 Requested: a. How is the Cost of Promotion and Sales? b. Create the Regression Equation. c. How much is the sale if the promotion is 20? d. How much is the sale if the promotion is 16? e. How much is the Promotion if sales are 90?...
Using the following unit data for a company that produces Product A and B, what is...
Using the following unit data for a company that produces Product A and B, what is the breakeven point (round to nearest unit) when fixed costs total $175,000? Product A Product B Units sold last year 2,250 1,000 Sales price $200 $450 Cost of goods sold   145   350 Sales commission     15     37 Variable costs   160   387 Contribution margin $ 40 $ 63
[The following information applies to the questions displayed below.] Company A B C D Sales $...
[The following information applies to the questions displayed below.] Company A B C D Sales $ 80,000 $ 180,000 $ 120,000 $ 100,000 Cost of goods sold 48,000 135,000 72,000 60,000 Gross margin 32,000 45,000 48,000 40,000 Operating expenses 9,600 12,600 10,800 10,000 Net income $ 22,400 $ 32,400 $ 37,200 $ 30,000 Based on common-sized income statements, which of the companies spent the least on operating expenses in relationship to its sales? Multiple Choice A Company A B Company...
Using the data presented below for Blue Sky Inc.: 2017 2016 Sales $7,550,000 $6,150,000 Cost of...
Using the data presented below for Blue Sky Inc.: 2017 2016 Sales $7,550,000 $6,150,000 Cost of Goods 5,750,000 4,550,000 Depreciation 120,000 100,000 Selling and G&A Expenses 820,000 730,000 Fixed Expenses 200,000 200,000 Lease Expense 150,000 150,000 Interest Expense 350,000 300,000 Tax Rate 40.00% 40.00% Shares Outstanding 100,000 80,000 Cash 108,000 50,000 Marketable Securities 150,000 100,000 Accounts Receivable 450,000 350,000 Inventory 1,250,000 850,000 Prepaid Expenses 120,000 40,000 Plant & Equipment 5,350,000 4,800,000 Accumulated Depreciation 410,000 290,000 Long Term Investments 450,000 360,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT