1

Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...

Question

Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...

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:

Debits Credits
Cash $

41,000

Accounts receivable

200,800

Inventory

57,900

Buildings and equipment (net)

351,000

Accounts payable $

85,425

Common stock

500,000

Retained earnings

65,275

$

650,700

$

650,700

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

December (actual) $

251,000

January $

386,000

February $

583,000

March $

297,000

April $

194,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, $16,000 per month: advertising, $56,000 per month; shipping, 5% of sales; other expenses, 3% of sales. Depreciation, including depreciation on new assets acquired during the quarter, will be $42,260 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 $1,100 cash. During March, other equipment will be purchased for cash at a cost of $70,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:

4. Prepare an absorption costing income statement for the quarter ending March 31.

5. Prepare a balance sheet as of March 31.

Answers


Hillyard Company Sales Budget Sales Cash Credit January February March Quarter 386000 583000 297000 1266000 77200 116600 5940

Cash Budget For the Quarter ending March 31... January February March Quarter Opening 41000 30000 2902541000 Collections 2780

1266000 Statement of Income For the Quarter ending March 31... Sales Less: Cost of goods sold: Opening Inventory 57900 Purcha


Similar Solved Questions

1 answers
Sullivan-Swift Mining Company must install $1.4 million of new machinery in its Nevada mine. It can...
Sullivan-Swift Mining Company must install $1.4 million of new machinery in its Nevada mine. It can obtain a bank loan for 100% of the required amount. Alternatively, a Nevada investment banking firm that represents a group of investors believes that it can arrange for a lease financing plan. Assume...
1 answers
Your company has purchased a large new trucktractor for over-the-road use (asset class 00.26). It has...
Your company has purchased a large new trucktractor for over-the-road use (asset class 00.26). It has a cost basis of $175,000. With additional options costing $14,000, the cost basis for depreciation purposes is $189,000. Its MV at the end of six years is estimated as $41,000. Assume it will be dep...
1 answers
But here. Search Your Package Tracked x P O bron Bro Bron N sho wa >...
but here. Search Your Package Tracked x P O bron Bro Bron N sho wa > + - w.com/in/takeAssignment/takeAssignment Main.dolinvoker assignments&takeAssignmentSessionLocator assignment-takeinprogree eBook Calculator Printem Dividing LLC Income Martin Farley and Ashley Clark formed a limited liabil...
1 answers
278 Chapter 32 Chapter Assignment Sheets O CASE STUDY 21 After explaining the procedure to the...
278 Chapter 32 Chapter Assignment Sheets O CASE STUDY 21 After explaining the procedure to the patient Mary Craie and her son lohn, Gwen Carr, CMA (AAN aplies a gait belt and begins the transfer of Mary from a car to a wheelchair in the parking lot of Inn Gry Health Care. Mary is an older adult who ...
1 answers
Question 2: A force with x, y, z components of F.-6 N-5 = 8 N and...
Question 2: A force with x, y, z components of F.-6 N-5 = 8 N and point (6,-8,5) m, determine: = 4 N is acting at a Directionn + or Magnitude with units Moment of F, about axis Fr about y axis F about z axis about x axis Fy about y axis Fy about z axis F about x axis F about y axis F about z axis...
1 answers
An automobile traveling 74.0 km/h has tires of 71.0 cm diameter. (a) What is the angular...
An automobile traveling 74.0 km/h has tires of 71.0 cm diameter. (a) What is the angular speed of the tires about their axles? (b) If the car is brought to a stop uniformly in 33.0 complete turns of the tires, what is the magnitude of the angular acceleration of the wheels? (c) How far does the car ...
2 answers
Chapter 3 Hand-out Assignment Question 1 One part of an adjusting entry is given below: 1....
Chapter 3 Hand-out Assignment Question 1 One part of an adjusting entry is given below: 1. Unearned Revenue is debited. 2. Prepaid Rent is credited. 3. Accounts Receivable is debited. 4. Depreciation Expense is debited. 5. Utilities Expense is debited. (give two possible debit accounts). 6. Interest...
1 answers
8. A bullet of mass m and speed v passes completely through a pendulum bob of...
8. A bullet of mass m and speed v passes completely through a pendulum bob of mass M. The bullet emerges with a speed of v/2. The pendulum bob is suspended by a stiff rod of length 1 and negligible mass. Use conservation of energy and momentum to find the minimum value of v such that the bob will ba...
1 answers
Answer it please On June 30, 2019, the balance sheet for the partnership of CC, MM,...
answer it please On June 30, 2019, the balance sheet for the partnership of CC, MM, and PP, together with their respective profit and loss ratios, were as follows: Assets (at cost) P180,000 CC, Loan 9,000 CC, Capital (20%) 42,000 MM, Capital (20%) 39,000 PP, Capital (60%) 90,000 CC decided to retir...
1 answers
Can someone unscramble these math words reaoprddrie enitmelgens
can someone unscramble these math wordsreaoprddrieenitmelgens...
1 answers
A.2 Based on your knowledge of ohms law applied to impedances, determine the current (magnitude and...
A.2 Based on your knowledge of ohms law applied to impedances, determine the current (magnitude and angle) in the circuit of figure 2.1, when the frequency of the voltage source is set to a) 100Hz, 1 KHz and 5 KHz. Compute the RMS and peak value of power for each of the given frequencies. Enter the ...
1 answers
(1 point) The set >-{[12][13) 45 is a basis for R2. Find the coordinates of the...
(1 point) The set >-{[12][13) 45 is a basis for R2. Find the coordinates of the vector i [13] relative to the basis B. []B =...
3 answers
Gleason Enterprises issued 10%, 7-year, $2,730,000 par value bonds that pay interest semiannually on October 1...
Gleason Enterprises issued 10%, 7-year, $2,730,000 par value bonds that pay interest semiannually on October 1 and April 1. The bonds are dated April 1, 2020, and are issued on that date. The discount rate of interest for such bonds on April 1, 2020, is 12%. What cash proceeds did Gleason receive fr...
1 answers
10. Find all solutions of the equation 4x +1-vx-2 3.
10. Find all solutions of the equation 4x +1-vx-2 3....
1 answers
3. Checking Account Balance. Andy has an account at South Central Savings and Loan. He does...
3. Checking Account Balance. Andy has an account at South Central Savings and Loan. He does not track his checking account balance on a checkbook register. Yesterday evening, he placed 2 checks in the mail, one for $189 and another for $237. Andy accesses his acccount online and finds that his balan...
1 answers
1) Using the map above, draw a picture of an appropriate targeting vector and draw a...
1) Using the map above, draw a picture of an appropriate targeting vector and draw a map of the gene after the neomycin resistance gene (neo) has been inserted. Review of Concepts: Gene Identification and Gene Knockout You want to study the physiological role of a gene you just cloned by making a &#...

-- 0.010716--