Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Basket Company specializes in unique baskets. Peak sales for one of their products, the Easter basket, occur in March every year. The company has estimated

Basket Company specializes in unique baskets.

Peak sales for one of their products, the Easter basket, occur in March every year.

The company has estimated the following sales for the first five months of the year for the Easter basket:

JANUARY

FEBRUARY

MARCH

APRIL

MAY

2 000

3 000

10 000

1 000

500

The company can sell the baskets for $30. Based on history, the company expects that 10% of sales are cash. Of the credit sales, half is collected one month after sale and the remainder is collected two months after sale. Accounts receivable as at January 1st was $50,000; all of which is expected to be collected in January.

The companys policy is having at the end of each month 20% of the following month sales. The inventory of finished goods at January 1st is estimated to be 500 units Each basket requires 2 meters of plastic. The cost per meter is $2.00. The company wants to ensure it always has enough plastic on hand and therefore has indicated that ending inventory will be 10% of the following month's production needs for plastic. The company had 1,080 meters of plastic on hand as at January 1st. The company puts all purchases of plastic on account and pays for it the month following purchase. Purchases of plastic in December amounted to $2,000. Each basket takes 1.5 hours to produce and the direct labor rate per hour is $12.00. The company expects to incur $40,000 of operating expenses each month, this includes $5,000 of depreciation expense.

The company plans to pay cash dividends of $3,000 in January. There is a minimum cash balance set by management of $5,000 at the end of each month. The company has access to a line of credit. Any borrowings and repayments must be made in multiples of $1,000. The company is subject to a 5% annual interest rate. For simplicity, assume interest is not compounded. Assume that borrowings are made at the beginning of the month and repayments are made at the end of the month. The company started the year with $10,000 in the bank. REQUIRED :

Prepare for the 1st quarter:

  1. A sales budget
  2. A cash receipts
  3. A production budget
  4. A direct material purchases budget
  5. A direct material disbursements budget
  6. A direct labor budget
  7. A combined cash budget

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

Managerial Accounting

Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

13th Edition

978-0073379616, 73379611, 978-0697789938

More Books

Students also viewed these Accounting questions