Questions
Heady Company sells headbands to retailers for $5. The variable cost of goods sold per headband...

Heady Company sells headbands to retailers for $5. The variable cost of goods sold per headband is $1, with a selling commission of 10 percent of sales. Fixed manufacturing costs total $25,000 per month, while fixed selling and administrative costs total $10,500. The income tax rate for Heady Company is 30 percent.

Required:

a. What is the break-even point in headbands?
b. What are target sales in headbands to generate a before-tax income of $3,000?
c. What are target sales in headbands to generate an after-tax income of $3,080?

In: Accounting

Pat’s Pizzeria produces three types of deli style pizzas: Thin Crust, Deep Dish, and Stuffed Crust....

Pat’s Pizzeria produces three types of deli style pizzas: Thin Crust, Deep Dish, and Stuffed Crust. Pat’s anticipated sales mix is 4:5:6 Thin:Deep:Stuffed. Current sales are 1,500 bundles per year.   

Thin Crust

Deep Dish

Stuffed Crust

Unit Selling Price

$15

$18

$20

Unit Variable Cost

$8

$10

$11

Fixed costs are estimated at $50,000, which include $44,000 for general overhead, such as rent, utilities, etc., and $6,000 for advertising. Pat’s tax rate is 20%.

Round all interim answers to 4 decimal places. For all questions, supporting calculations MUST be included.

  1. What is the operating leverage ratio when 1,500 bundles are sold?

If sales increase by 15% from this level, by what percentage should Pat expect profit before tax to increase?

How much is this increase in dollars?

What is Pat’s expected profit before tax in dollars?

B. What is Pat’s margin of safety, in units of each type of pizza, at current level of sales?

C. Prepare a contribution margin income statement for the level of sales required to earn $100,000 of before tax profits. Show revenues and variable costs for each type of pizza in the contribution margin income statement.

D. If Pat increases advertising costs by 200%, sales of all types of pizzas are expected to increase by 12% above the original sales levels. Assuming the sales mix will remain the same, should Pat increase her advertising expenditure? Why or why not?

E. What is the minimum percentage sales would need to increase before Pat would consider the additional advertising? (Hint- at what point will she not lose anything?)

(Return to the original problem assumptions for parts F – G. Do not assume advertising has been increased.)

F. How many bundles of pizza will Pat have to sell to earn after-tax profits equal to 15% of revenue?

G. In analyzing results at the end of the year, Pat discovered that, although she sold 22,500 pizzas as planned, the actual sales mix was 6 Thin Crust, 6 Deep Dish, and 3 Stuffed Crust pizzas. How did Pat’s actual profit differ from her projected profit?   Explain why this happened.

In: Accounting

The separate condensed balance sheet of Patrick Corporation and its wholly-owned subsidiary, Sean Corporation, are as...

The separate condensed balance sheet of Patrick Corporation and its wholly-owned subsidiary, Sean Corporation, are as follows:

Balance Sheets

December 31, 2020

Patrick

Sean

Cash

$      80,000

$   60,000

Accounts Receivable (net)

      140,000

     25,000

Inventories

        90,000

   50,000

Plant & equipment (net)

      625,000

   280,000

Investment in Sean

      460,000

Total Assets

$ 1,395,000

$ 415,000

Accounts Payable

$ 160,000

$   95,000

Long-term Debt

    110,000

    30,000

Common Stock ($10 par)

    340,000

     50,000

Additional paid-in capital

     10,000

Retained Earnings

    785,000

   230,000

Total Liabilities & Stockholders’ Equity

$1,395,000

$415,000

Additional Information:
* On December 31, 2020, Patrick acquired 100% of Sean’s voting stock in exchange for $460,000.
* At the acquisition date, the fair values of Sean’s assets and liabilities equaled their carrying amounts, respectively, except that the fair value of certain items in Sean’s inventory were $25,000 more than their carrying amounts.

1. In the December 31, 2020, consolidated balance sheet of Patrick and its subsidiary, what amount
of total assets should be reported?

2. In the December 31, 2020, consolidated balance sheet of Patrick and its subsidiary, what amount
of total stockholders’ equity should be reported?

In: Accounting

As a recently hired MBA intern, you are working in a consulting capacity to provide an...

As a recently hired MBA intern, you are working in a consulting capacity to provide an analysis for Al Dente's Italian Restaurant. A financial income Statement is presented below: Sales $2,698,000 Cost of sales (all variable) $1,557,563 Gross Margin $1,140,438 Operating expenses: Variable $277,975 Fixed $213,675 Total operating expenses: $491,650 Administative expenses (all fixed) $564,375 Net operating income $84,413 This income statement presents the sales, expenses and pre-tax operating income for a local eating facility. At Al Dente, the average meal cost for lunches and dinners are $20 and $40 respectively. Al Dente serves both lunch and dinner 300 days per year and serves twice as many lunches as dinners. As the MBA intern you are to prepare a managerial accounting focused report to the owners of Al Dente's Italian Restaurant, to include the following:

1. Prepare a contribution margin income statement using the given financial data. Use the following format:

Sales

Variable costs

Cost of sales

Operating

Total variable costs

Contribution margin

Fixed costs

Operating

Administrative

Total fixed costs

Net operating income

In: Accounting

Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States...

Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States and Canada. The agents are currently paid an 18% commission on sales; that percentage was used when Lionel prepared the following budgeted income statement for the fiscal year ending June 30, 2019:

Lionel Corporation
Budgeted Income Statement
For the Year Ending June 30, 2019
($000 omitted)
Sales $ 29,500
Cost of goods sold
Variable $ 13,275
Fixed 3,540 16,815
Gross profit $ 12,685
Selling and administrative costs
Commissions $ 5,310
Fixed advertising cost 885
Fixed administrative cost 2,360 8,555
Operating income $ 4,130
Fixed interest cost 738
Income before income taxes $ 3,392
Income taxes (30%) 1,018
Net income $ 2,374

Since the completion of the income statement, Lionel has learned that its sales agents are requiring a 5% increase in their commission rate (to 23%) for the upcoming year. As a result, Lionel’s president has decided to investigate the possibility of hiring its own sales staff in place of the network of sales agents and has asked Alan Chen, Lionel’s controller, to gather information on the costs associated with this change.

Alan estimates that Lionel must hire eight salespeople to cover the current market area, at an average annual payroll cost for each employee of $80,000, including fringe benefits expense. Travel and entertainment expenses is expected to total $700,000 for the year, and the annual cost of hiring a sales manager and sales secretary will be $200,000. In addition to their salaries, the eight salespeople will each earn commissions at the rate of 10% of sales. The president believes that Lionel also should increase its advertising budget by $600,000 if the eight salespeople are hired.

Required

1. Determine Lionel’s breakeven point (operating profit = 0) in sales dollars for the fiscal year ending June 30, 2019, if the company hires its own sales force and increases its advertising costs. Prove this by constructing a contribution income statement.

2. If Lionel continues to sell through its network of sales agents and pays the higher commission rate, determine the estimated volume in sales dollars that would be required to generate the operating profit as projected in the budgeted income statement.

In: Accounting

Question 5 Partially correct Mark 2.00 out of 4.00 Flag question Edit question Question text ROI...

Question 5

Partially correct

Mark 2.00 out of 4.00

Flag question

Edit question

Question text

ROI and Residual Income:
Impact of a New Investment
The Mustang Division of Detroit Motors had an operating income of $700,000 and net assets of $4,000,000. Detroit Motors has a target rate of return of 16 percent.

(a) Compute the return on investment. (Round your answer to three decimal places.)
Answer



(b) Compute the residual income.
$Answer



(c) The Mustang Division has an opportunity to increase operating income by $200,000 with an $950,000 investment in assets.

1. Compute the Mustang Division's return on investment if the project is undertaken. (Round your answer to three decimal places.)
Answer



2. Compute the Mustang Division's residual income if the project is undertaken.
$Answer

In: Accounting

The companies Act, 71 of 2008, allows for the board of a company to appoint a...

The companies Act, 71 of 2008, allows for the board of a company to appoint a number of committees.

1. How can one ensure that committees, once they are established, functions effectively.

2.Do you think that it is correct to say that king IV is silent on the issue of committees? Fully motivate your answer.

3.The establishment of an audit committee is a legislative requirements. Describe the responsibilities of the Audit committee as reflected in the companies Act.

Question 3

3.1 King IV establishes principles and make recommendations in relation to "ethical leadership" and the establishment of an "ethical culture" in organization. List the relevant principles and discuss the recommendations made by king IV on how to implement these principles in your organization.

3.2 The issue of "responsible investing" has become very important n recent years.

3.2.1 Explain what the objectives were when the code for responsible investing in south Africa (CRISA) was when it was launched in 2012?

3.2.2 To whom was it applicable?

3.2.3 Discuss the principles that it wishes to establish.

3.3.4 Describe how the CRISA principles relate to principle 17 of king IV.

3

In: Accounting

On January 1, 2017, Pepper purchased 75% of the outstanding shares of Salt for $1,275,000. At...

On January 1, 2017, Pepper purchased 75% of the outstanding shares of Salt for $1,275,000. At that time, Salt’s assets and liabilities had the following book and fair values.

SALT LTD.

January 1, 2017

Book value

Fair value

Cash

$140,000

$140,000

A/R

350,000

350,000

Inventory

345,000

345,000

Capital asset

1,000,000

1,070,000

1,835,000

1,905,000

A/P

255,000

255,000

Common shares

300,000

R/E

1,280,000

1,835,000

Capital assets have a 10-year remaining life.

Balance Sheet

Dec 31, 2017

Pepper

Salt

Cash

$90,000

$160,000

A/R

350,000

410,000

Inventory

420,000

564,000

Capital assets

2,075,000

950,000

Investment in salt

1,275,000

-

$4,210,000

$2,084,000

A/P

$55,000

$377,000

Deferred income tax

75,000

60,000

Long-term debt

900,000

-

Common shares

600,000

300,000

R/E

2,580,000

1,347,000

$4,210,000

$2,084,000

Statements of Income and Retained Earnings

Year ended Dec 31, 2017

Pepper

Salt

Sales

$3,750,000

$980,000

COGS

2,500,000

392,000

1,250,000

588,000

Other expenses

755,000

328,000

Interest on long-term debt

90,000

-

Depreciation

70,000

50,000

Other income

(60,000)

-

855,000

378,000

Net income before tax

395,000

210,000

Income tax

124,500

63,000

Net income after tax

270,500

147,000

Retained earnings, Jan 1, 2017

2,459,500

1,280,000

Dividends declared

(150,000)

(80,000)

Retained earnings, Dec 31, 2017

2,580,000

1,347,000

During 2017, Pepper sold goods to Salt for $130,000. These goods cost Pepper $85,000. Salt sold 60% of these goods during 2017. Also, during 2017, Salt sold goods to Pepper for $90,000, earning a gross profit of 40%. Pepper had 20% of these goods in its 2017 ending inventory. The tax rate for both companies is 30%. On December 31, 2017, Pepper determined that there was a $3,000 goodwill impairment.

Required:

Note: The calculations in part 1 are required to earn marks in part 2. Assignments submitted without supporting calculations will receive zero for this question.

Pepper accounts for Salt using the entity theory and cost methods.

  1. Calculate the following for consolidated financial statements. (2 marks)
    1. a) Goodwill using fair values
    2. b) Acquisition differential, and prepare the ADA table
    3. c) Unrealized inventory profits before and after tax
    4. d) Consolidated net income and the NCI share
    5. e) Consolidated retained earnings and NCI Balance Sheet

Prepare a consolidated income statement that includes a section below net income attributing income to shareholders of Pepper and NCI shareholders. Prepare a consolidated balance sheet for 2017. Prepare these statements in good form. (18 marks)

In: Accounting

Allison Corporation acquired all of the outstanding voting stock of Mathias, Inc., on January 1, 2020,...

Allison Corporation acquired all of the outstanding voting stock of Mathias, Inc., on January 1, 2020, in exchange for $5,998,000 in cash. Allison intends to maintain Mathias as a wholly owned subsidiary. Both companies have December 31 fiscal year-ends. At the acquisition date, Mathias’s stockholders’ equity was $2,030,000 including retained earnings of $1,530,000.

At the acquisition date, Allison prepared the following fair-value allocation schedule for its newly acquired subsidiary:

Consideration transferred $ 5,998,000
Mathias stockholders' equity 2,030,000
Excess fair over book value $ 3,968,000
to unpatented technology (8-year remaining life) $ 848,000
to patents (10-year remaining life) 2,560,000
to increase long-term debt (undervalued, 5-year remaining life) (130,000 ) 3,278,000
Goodwill $ 690,000

Post acquisition, Allison employs the equity method to account for its investment in Mathias. During the two years following the business combination, Mathias reports the following income and dividends:

Income Dividends
2020 $ 468,750 $ 25,000
2021 937,500 50,000

No asset impairments have occurred since the acquisition date.

Individual financial statements for each company as of December 31, 2021, follow. Parentheses indicate credit balances. Dividends declared were paid in the same period

Allison Mathias
Income Statement
Sales $ (6,520,000 ) $ (3,930,000 )
Cost of goods sold 4,584,000 2,519,500
Depreciation expense 905,000 295,000
Amortization expense 445,000 112,000
Interest expense 67,000 66,000
Equity earnings in Mathias (601,500 ) 0
Net income $ (1,120,500 ) $ (937,500 )
Statement of Retained Earnings
Retained earnings 1/1 $ (5,400,000 ) $ (1,973,750 )
Net income (above) (1,120,500 ) (937,500 )
Dividends declared 560,000 50,000
Retained earnings 12/31 $ (5,960,500 ) $ (2,861,250

)

Balance Sheet
Cash $ 84,000 $ 152,000
Accounts receivable 980,000 240,000
Inventory 1,760,000 815,000
Investment in Mathias 6,657,250 0
Equipment (net) 3,760,000 2,073,000
Patents 110,000 0
Unpatented technology 2,155,000 1,480,000
Goodwill 446,000 0
Total assets $ 15,952,250 $ 4,760,000
Accounts payable $ (791,750 ) $ (198,750 )
Long-term debt (1,000,000 ) (1,200,000 )
Common stock (8,200,000 ) (500,000 )
Retained earnings 12/31 (5,960,500 ) (2,861,250 )

Total liabilities and equity$(15,952,250) $(4,760,000)

1. Determine the fair value in excess of book value for Allison's acquisition date investment in Mathias.

2. Prepare a worksheet to determine the consolidated values to be reported on Allison’s financial statements.

In: Accounting

The following cost data for the year just ended pertain to Sentiments, Inc., a greeting card...

The following cost data for the year just ended pertain to Sentiments, Inc., a greeting card manufacturer:

Direct material    $2,100,000
Advertising expense 97,000
Depreciation on factory building 117,000
Direct labor: wages 545,000
Cost of finished goods inventory at year-end 115,000
Indirect labor: wages 140,000
Production supervisor’s salary 47,000
Service department costs* 100,000
Direct labor: fringe benefits 94,000
Indirect labor: fringe benefits 32,000
Fringe benefits for production supervisor 10,000
Total overtime premiums paid    55,000
Cost of idle time: production employees§ 40,000
Administrative costs 150,000
Rental of office space for sales personnel 15,000
Sales commissions 4,000
Product promotion costs 10,000

*All services are provided to manufacturing departments.

§Cost of idle time is an overhead item; it is not included in the direct-labor wages given above.

†The rental of sales space was made necessary when the sales offices were converted to storage space for raw material.

Required:
1. Compute each of the following costs for the year just ended:

a. Total prime costs
b. Total manufacturing overhead costs
c. Total conversion costs
d. Total product costs
e. Total period costs $276,000

In: Accounting

Question 3 Partially correct Mark 54.34 out of 98.00 Flag question Edit question Question text Developing...

Question 3

Partially correct

Mark 54.34 out of 98.00

Flag question

Edit question

Question text

Developing a Master Budget
for a Merchandising Organization
Peyton Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2010.

PEYTON DEPARTMENT STORE
Balance Sheet
March 31, 2010
Assets

Liabilities and Stockholders' Equity

Cash $4,000

Accounts payable

$26,000
Accounts receivable 25,000

Dividends payable

17,000
Inventory 30,000

Rent payable

3,000
Prepaid Insurance 2,000

Stockholders' equity

40,000
Fixtures 25,000
Total assets $86,000

Total liabilities and equity

$86,000

Actual and forecasted sales for selected months in 2010 are as follows:

Month Sales Revenue
January $40,000
February 50,000
March 40,000
April 50,000
May 60,000
June 70,000
July 90,000
August 80,000

Monthly operating expenses are as follows:

Wages and salaries $26,000
Depreciation 100
Utilities 1,000
Rent 3,000

Cash dividends of $17,000 are declared during the third month of each quarter and are paid during the first month of the following quarter. Operating expenses, except insurance, rent, and depreciation are paid as incurred. Rent is paid during the following month. The prepaid insurance is for five more months. Cost of goods sold is equal to 50 percent of sales. Ending inventories are sufficient for 120 percent of the next month's sales. Purchases during any given month are paid in full during the following month. All sales are on account, with 50 percent collected during the month of sale, 40 percent during the next month, and 10 percent during the month thereafter. Money can be borrowed and repaid in multiples of $1,000 at an interest rate of 12 percent per year. The company desires a minimum cash balance of $4,000 on the first of each month. At the time the principal is repaid, interest is paid on the portion of principal that is repaid. All borrowing is at the beginning of the month, and all repayment is at the end of the month. Money is never repaid at the end of the month it is borrowed.

  • Part A
  • Part B
  • Part C
  • Part D
  • Part E
  • Part F

(c) Prepare a cash disbursements schedule for each month of the second quarter ending June 30, 2010. Do not include repayments of borrowings.

Peyton Department Store
Schedule of Monthly Cash Disbursements
Quarter Ending June 30, 2010
April May June Total
Total cash disbursements Answer Answer Answer Answer

(d) Prepare a cash budget for each month of the second quarter ending June 30, 2010. Include budgeted borrowings and repayments.

Only use negative signs, if needed, for: excess receipts over disbursements, balance before borrowings and cash balances (beginning and ending).

Peyton Department Store
Monthly Cash Budget
Quarter Ending June 30, 2010
April May June Total
Cash balance, beginning Answer Answer Answer Answer
Receipts Answer Answer Answer Answer
Disbursements Answer Answer Answer Answer
Excess receipts over disb. Answer Answer Answer Answer
Balance before borrowings Answer Answer Answer Answer
Borrowings Answer Answer Answer Answer
Loan repayments Answer Answer Answer Answer
Cash balance, ending Answer Answer Answer Answer

(e) Prepare an income statement for each month of the second quarter ending June 30, 2010.

Only use negative signs to show net losses in income.

Peyton Department Store
Budgeted Monthly Income Statements
Quarter Ending June 30, 2010
April May June Total
Sales Answer Answer Answer Answer
Cost of sales Answer Answer Answer Answer
Gross profit Answer Answer Answer Answer
Operating expenses:
Wages and salaries Answer Answer Answer Answer
Depreciation Answer Answer Answer Answer
Utilities Answer Answer Answer Answer
Rent Answer Answer Answer Answer
Insurance Answer Answer Answer Answer
Interest Answer Answer Answer Answer
Total expenses Answer Answer Answer Answer
Net income Answer Answer Answer Answer

(f) Prepare a budgeted balance sheet as of June 30, 2010.

Peyton Department Store
Budgeted Balance Sheet
June 30, 2010
Assets Liabilities and Equity
Cash Answer Merchandise payable Answer
Accounts receivable Answer Dividend payable Answer
Inventory Answer Rent payable Answer
Prepaid insurance Answer Loans payable Answer
Fixtures Answer Interest payable Answer
Total assets Answer Stockholders' equity Answer
Total liab. & equity Answer

In: Accounting

Companies that have a high demand for making copies, both color and black and white, often...

Companies that have a high demand for making copies, both color and black and white, often choose to lease a high-end copier that provides fast and reliable service at a reasonable cost. The lease is usually for 3 to 5 years, and the cost to the user is $0.18 per page for black-and-white copies and typically $0.255 per page for color copies. These are the terms of your current 3-year lease contract with Ricoh Company, which is up for renewal this month; the lease terms are expected to be the same for the next 3 years, if renewed.

Hewlett-Packard Company (HP) developed an innovative copier that can reduce the cost of color copies. The copier measures exactly how much color is used in a color copy so that the price of the copy can be determined by the amount of color used rather than a fixed price per page. The cost could be as low as $0.246 per page for a color copy. HP calls this a “flexible-pricing” approach. Assume for this example that the cost of the leased copier (3-year lease) is only the per-page charge—the initial lease cost is negligible, and the service costs would not differ between the HP copier and the copier you are using now.

Your company is an advertising agency, Tanner and Jones LLC, and the quality of the color copies is critical to your business success. The ability to rely on the copier at any time is also very important because some customer requests require urgent attention. You believe that the Ricoh and HP printers are of the same reliability, but you have not had experience with the HP copier to be sure of the copy quality. The demonstration of the HP copier has shown as good or better copy quality, but you have not had 3 years’ experience with it to know what it would be like day-to-day.

Required:

1. Assume that your company is considering the lease of one of these HP copiers, and you expect that the average price for a color copy for your company would be $0.246 because you would carefully prioritize color copy jobs and reduce the number of copies requiring a large amount of color. You expect that training your copy center staff to properly use the new copier would cost about $2,754 for materials and lost work time. What is the breakeven number of color copies per year that would make you indifferent between the new HP copier and your current copier? (Do not round intermediate calculations. Round your answer to the nearest whole number.)

2. As in requirement 1, assume you expect that your per-copy cost for color copies with the HP copier will be $0.246, the training costs are $2,754, and you expect to make 260,000 copies per year for the next 3 years. In your negotiations with Ricoh concerning the new lease and the cost of color copies, what price would you bargain for? (Round your answer to 4 decimal places.)

In: Accounting

Absorption and variable costing Bird’s Eye View manufactures satellite dishes used in residential and commercial installations...

Absorption and variable costing
Bird’s Eye View manufactures satellite dishes used in residential and commercial installations for satellite-broadcasted television. For each unit, the following costs apply: $50 for direct material, $100 for direct labor, and $60 for variable overhead. The company’s annual fixed overhead cost is $300,000; it uses expected capacity of 5,000 units produced as the basis for applying fixed overhead to products. A commission of 10 percent of the selling price is paid on each unit sold. Annual fixed selling and administrative expenses are $72,000. The following additional information is available:

Year 1 Year 2
Selling price per unit $500 $500
Number of units sold 4,000 4,800
Number of units produced 5,000 4,400
Beginning inventory (units) 3,000 4,000
Ending inventory (units) 4,000 ?

a. Prepare pre-tax income statements under absorption and variable costing for Year 1 and Year 2, with any volume variance being charged to Cost of Goods Sold.
Note: Do not use negative signs in your answers.

Bird’s Eye View
Income Statements (Absorption)
For the Years Ended December 31, Year 1 and Year 2
Year 1 Year 2
Sales Answer Answer
CGS Answer Answer
Underapplied FOH Answer Answer Answer Answer
Gross profit Answer Answer
S&A:
Variable Answer Answer
Fixed Answer Answer Answer Answer
Income before taxes Answer Answer

b. Prepare pre-tax income statements under variable costing for Year 1 and Year 2, with any volume variance being charged to Cost of Goods Sold.
Note: Do not use negative signs in your answers.

Bird’s Eye View
Income Statements (Variable)
For the Years Ended December 31, Year 1 and Year 2
Year 1 Year 2
Sales Answer Answer
CGS Answer Answer
Product CM Answer Answer
Variable S&A Answer Answer
Total CM Answer Answer
Fixed costs:
Factory Answer Answer
S&A Answer Answer Answer Answer
Income before taxes Answer Answer

c. Reconcile the differences in income for the two methods.

Year 1 Year 2
Net income (absorption) Answer Answer
Net income (variable) Answer Answer
Difference in income Answer Answer
Difference equals inventory change Answer Answer
Times FOH application rate Answer Answer
Difference in income Answer Answer

In: Accounting

Problem 2-03A a-d (Video) Tom Zopf owns and manages a computer repair service, which had the...

Problem 2-03A a-d (Video)

Tom Zopf owns and manages a computer repair service, which had the following trial balance on December 31, 2019 (the end of its fiscal year).

Oriole Company
Trial balance
December 31, 2019

Debit

Credit

Cash

$ 7,300

Accounts Receivable

15,200

Supplies

12,000

Prepaid Rent

1,400

Equipment

20,500

Accounts Payable

$14,400

Common Stock

31,000

Retained Earnings

    

11,000

$56,400

$56,400


Summarized transactions for January 2020 were as follows.

1. Advertising costs, paid in cash, $1,150.
2. Additional supplies acquired on account $4,380.
3. Miscellaneous expenses, paid in cash, $1,790.
4. Cash collected from customers in payment of accounts receivable $12,240.
5. Cash paid to creditors for accounts payable due $12,620.
6. Repair services performed during January: for cash $6,850; on account $9,130.
7. Wages for January, paid in cash, $2,090.
8. Dividends during January were $2,500.

Post the journal entries to the accounts in the ledger. (Post entries in the order of journal entries presented in the previous part.)

In: Accounting

Problem 8-31 Completing a Master Budget Hillyard Company, an office supplies specialty store, prepares its master...

Problem 8-31 Completing a Master Budget

Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter:

  1. As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances:

Cash $

63,000

Accounts receivable

218,400

Inventory

61,200

Buildings and equipment (net)

373,000

Accounts payable $

92,025

Common stock

500,000

Retained earnings

123,575

$

715,600

$

715,600

  1. Actual sales for December and budgeted sales for the next four months are as follows:

December(actual) $

273,000

January $

408,000

February $

605,000

March $

320,000

April $

216,000

  1. Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December 31 are a result of December credit sales.

  2. The company’s gross margin is 40% of sales. (In other words, cost of goods sold is 60% of sales.)

  3. Monthly expenses are budgeted as follows: salaries and wages, $38,000 per month: advertising, $58,000 per month; shipping, 5% of sales; other expenses, 3% of sales. Depreciation, including depreciation on new assets acquired during the quarter, will be $45,780 for the quarter.

  4. Each month’s ending inventory should equal 25% of the following month’s cost of goods sold.

  5. One-half of a month’s inventory purchases is paid for in the month of purchase; the other half is paid in the following month.

  6. During February, the company will purchase a new copy machine for $3,300 cash. During March, other equipment will be purchased for cash at a cost of $81,500.

  7. During January, the company will declare and pay $45,000 in cash dividends.

  8. Management wants to maintain a minimum cash balance of $30,000. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.

Required:

Using the data above, complete the following statements and schedules for the first quarter:

1. Schedule of expected cash collections:

2-a. Merchandise purchases budget:

2-b. Schedule of expected cash disbursements for merchandise purchases:

3. Cash budget:

1. Complete the Schedule of expected cash collections:

Schedule of Expected Cash Collections
January February March Quarter
Cash sales $81,600
Credit sales 218,400
Total collections $300,000

2A. Complete the merchandise purchases budget:

Merchandise Purchases Budget
January February March Quarter
Budgeted cost of goods sold 244,800* $363,000
Add desired ending inventory 90,750†
Total needs 335,550
Less beginning inventory 61,200
Required purchases $274,350
*$408,000 sales × 60% cost ratio = $244,800.
†$363,000 × 25% = $90,750.

2B. Complete the schedule of expected cash disbursements for merchandise purchases.

Schedule of Expected Cash Disbursements for Merchandise Purchases
January February March Quarter
December purchases $92,025
January purchases 137,175 137,175
February purchases
March purchases
Total cash disbursements for purchases

3. Complete the cash budget. (Cash deficiency, repayments and interest should be indicated by a minus sign.)

Hillyard Company
Cash Budget
January February March Quarter
Beginning cash balance $63,000
Add cash collections 300,000
Total cash available
Less cash disbursements:
Inventory purchases 229,200
Selling and administrative expenses 128,640
Equipment purchases
Cash dividends 45,000
Total cash disbursements 402,840
Excess (deficiency) of cash
Financing:
Borrowings
Repayments
Interest
Total financing
Ending cash balance

In: Accounting