Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Jackmar Inc. is preparing budgets for the upcoming quarter, April to June. Budgeted sales (in units) for the next five months are: April 14,100 May

Jackmar Inc. is preparing budgets for the upcoming quarter, April to June. Budgeted sales (in units) for the next five months are:

April

14,100

May

27,300

June

25,200

July

18,600

August

17,700

Below is additional information that may be relevant in preparing the budgets.

  • The company produces and sells a product for $25.00 per unit.
  • To guard against inventory stockouts, the company has a policy of maintaining an ending inventory of 20% of the following months budgeted sales. At the beginning of April, the company had 2,820 units in inventory.
  • Each unit of output requires 2 kilograms of direct material. To guard against stockouts of raw materials, the company has a policy of maintaining a raw materials inventory of 15% of the following months production. At the beginning of April, the company has 5,022 kilograms of direct materials on hand. Each kilogram of direct materials costs $3.00.
  • Each unit of output requires 0.2 hours (12 minutes) of direct labour and employees are paid a standard rate of $22.00 per hour.

  • The company applies overhead using a variable rate of $10.00 per direct labour hour. The fixed overhead is $22,500 per month.sn
  • Fifty percent of sales are made in cash. The remaining 50% of sales are made on account. The company collects 60% of sales made on account in the month of the sale, 20% in the month following the sale, and 12% in the second month following the sale. The company had total sales revenue of $157,500 in February and $236,250 in March.
  • The company pays of half of its direct materials purchases in the month of the purchase and the remaining half in the month following the purchase. At the beginning of the quarter, the company owed its creditors $34,002 for purchases of direct materials made in March.

Required:

  1. Prepare the ending finished goods inventory budget for the quarter ending June 30th.

  1. Prepare a schedule showing cash collections (accounts receivable) from sales expected for the months of April, May, and June.

  1. Prepare the cash payments on accounts payable schedule (case disbursements) for the months of April, May, and June.

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

Payroll Accounting 2022

Authors: Jeanette Landin

8th Edition

126072879X, 9781260728798

More Books

Students also viewed these Accounting questions

Question

3 7 6 .

Answered: 1 week ago

Question

2 What is the philosophy of performance management?

Answered: 1 week ago