Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ralphs Horse Feed Ltd. is a retailer that sells bales of specialized horse feed. The company is planning its cash needs for the month of

Ralphs Horse Feed Ltd. is a retailer that sells bales of specialized horse feed. The company is planning its cash needs for the month of January, 2021. The statement of financial position showed the following at December 31, 2020.

Assets

Current

Cash

$ 25,000

Accounts receivable

80,000

Inventory

12,000

117,000

PPE, net

900,000

$1,017,000

Liabilities

Current

Operating loan

$190,000

Accounts payable

12,514

202,514

Non-current borrowings

700,000

902,514

Shareholders Equity

Share capital

70,000

Retained earnings

44,486

114,486

$1,017,000

Other information:

  1. Sales are 30% for cash and 70% on credit each month. January sales are projected to be $120,000 (2,000 bales). The gross profit ratio [[sales COGS)/sales] is estimated at 50%.
  2. Credit sales are collected over a three-month period with 20% collected in the month of sale, 70% in the following month, and 10% in the second month following sale. November 2020 credit sales totaled $80,000 and December credit sales totaled $90,000.
  3. 60% of a months inventory purchases are paid for in the same month. The remaining 40% are paid in the following month. Accounts payable at December 31, 2020 relate solely to inventory purchases.
  4. The company maintains its ending inventory levels at 20% of the cost of the merchandise to be sold in the following month. February 2021 sales are budgeted at $110,000. The gross profit ratio is estimated to be 45%.
  5. Variable expenses besides cost of goods sold relate to commissions on sales. Commissions amount to 10% of each months total sales. They are paid in the month incurred.
  6. Fixed expenses total $15,000 per month. They are composed of $5,000 of depreciation, $8,000 of salaries and benefits, and $2,000 of other operating expenses. All non-depreciation items are paid in cash by the end of each month.
  7. The company pays a $2,000 monthly cash dividend to shareholders.
  8. The operating loan is not due on demand. Interest on the operating loan and non-current debt is 1% per month, calculated on the balance at the start of each month. Interest is paid in cash each month.
  9. The non-current loan is repayable at $1,000 per month.
  10. The corporate income tax rate is 25% of income before income taxes. Income taxes will be paid in cash in April 2021. No income taxes were owing at December 31, 2020.
  11. January budgeted cash purchases of property, plant, and equipment are $120,000. Depreciation will be unaffected.
  12. Management wants to maintain a cash balance of $20,000 at the end of each month. The maximum operating loan is $200,000. Additional non-current borrowing will be incurred to make up any cash deficiency.
    1. (6 marks) Assume the actual results for January 2021 are as follows, and that no additional staff were hired:

Sales (2,200 bales) $121,000

Commissions expense 10,890

Cost of goods sold 54,450

Depreciation 5,000

Salaries expense 8,500

Other operating expenses 2,000

Interest expense 11,125

Income tax expense 7,259

Analyze the variances and suggest one possible explanation for each one. Assume that flexible budget amounts for fixed expenses are the same as master budget amounts

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Cost Accounting

Authors: J.K. Mitra

1st Edition

8122425941, 978-8122425949

More Books

Students also viewed these Accounting questions