Question

The sales budget is provided below for the product of Company ABC. Jan 30,000 units Feb...

The sales budget is provided below for the product of Company ABC.

Jan

30,000 units

Feb

20,000 units

Mar

10,000 units

Apr

20,000 units

May

30,000 units
  1. Finished goods at the end of each month must be 10% of the next month’s budgeted sales.
  2. On Dec 31 of the last year, the finished goods totaled 2,000 units.
  3. The selling price is $1 per unit.
  4. 80% of the credit sales are collected in the month of sale, 15% in the month following sale, and the remainder are uncollectible.
  1. Prepare a budget showing the required production each month for January, February, March, and the quarter.
  2. Prepare the cash collection for each month for January, February, March, and the quarter. (5 marks
Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A sales budget is given below for one of the products manufactured by the Key Co.:...
A sales budget is given below for one of the products manufactured by the Key Co.: Sales Budget in Units January 20,000 February 35,000 March 60,000 April 40,000 May 30,000 June 25,000 The inventory of finished goods at the end of each month must equal 17% of the next month’s sales. On December 31, the finished goods inventory totaled 3,400 units. Each unit of product requires three specialized electrical switches. Since the production of these specialized switches by Key’s suppliers...
Cash Collections Budget - Company A reports the following sales and collection information: Nov. Dec. Jan....
Cash Collections Budget - Company A reports the following sales and collection information: Nov. Dec. Jan. Feb. Mar. Apr. Sales . . . $200,000 $325,000 $250,000 $240,000 $260,000 $270,000 (a) Assume Company A collects 20% of its sales in the month of the sale, 50% the next month, 25% the following month, and 5% is never collected. Compute the company's cash collections for each month from January through April. (Include formulas used to solve problem). Cash Collection Budget - Company...
A sales budget is given below for one of the products manufactured by the OMI Co.:...
A sales budget is given below for one of the products manufactured by the OMI Co.: January 25,000 units February 40,000 units March 65,000 units April 45,000 units May 35,000 units June 30,000 units The inventory of finished goods at the end of each month must equal 20% of the next month's sales. However, on December 31 the finished goods inventory totaled only 4,000 units. Each unit of product requires three pounds of specialized material. The requires an ending inventory...
Aretes expects total sales of $699,500 for January and $355,000 for February. Assume that Aretes's sales...
Aretes expects total sales of $699,500 for January and $355,000 for February. Assume that Aretes's sales are collected as follows: 60% in the month of the sale 20% in the month after the sale 17% two months after the sale 3% never collected November sales totaled $392,000 and December sales were $400,000. Prepare a schedule of cash receipts from customers for January and February. Round answers to the nearest dollar. (If a bix is not used in the table leave...
Galactic Inc. manufactures flying drone toys. Sales units for January, February, March, April and May were...
Galactic Inc. manufactures flying drone toys. Sales units for January, February, March, April and May were 700, 680, 752, 712, and 780 respectively. Required: 1. The company’s policy for ending finished goods is 25 percent of next month's sales. Prepare a production budget for the first quarter. 2. The drone toy includes 2 LED lights, which cost $15 each. The company requires ending direct materials to be 20 percent of next month's materials requirement. Prepare a direct materials purchases budget...
The Bear Corporation will begin business operations on January 1, 2015. Below is the anticipated SALES...
The Bear Corporation will begin business operations on January 1, 2015. Below is the anticipated SALES BUDGET (in units):    Jan.                 __0,000 Feb.                 __0,000 Mar.                __0,000 Apr.                __0,000 May                __0,000    To complete the unit sales forecast, use the third, fourth, fifth and sixth digits of your student identification number to fill in the blanks.   If any of these digits contains a "0", use "3" instead.                     Example:   If student ID number is 00607357.   The sales forecast would be: January           ...
Gadget toys expects the following sales in units in the last quarter (Oct-Dec) of 2019: Oct...
Gadget toys expects the following sales in units in the last quarter (Oct-Dec) of 2019: Oct 22,000; Nov 29,000; Dec 33,000 and 30,000 for January 2020. The business has inventory of 24,000 finished units on hand at 1st October and has a target finished inventory of 50% of the following month’s sales units. The units are purchased for $10 and sold for $16 each. Payment for purchases is made in the month following purchase. Accounts payable for purchases as at...
Joshua Hill, Bramble & Hill Fabricators' production manager, has just received the company's sales budget for...
Joshua Hill, Bramble & Hill Fabricators' production manager, has just received the company's sales budget for the first quarter. January February March April May June 18,600 36,270 32,550 26,970 23,000 20,000 Company policy requires an ending finished goods inventory each month that will meet 19% of the following month's sales volume. Joshua plans to have 5,208 finished bricks at a cost of $45,570 in inventory at the beginning of the year. Prepare Bramble & Hill's production budget for the first...
oshua Hill, Coronado & Hill Fabricators' production manager, has just received the company's sales budget for...
oshua Hill, Coronado & Hill Fabricators' production manager, has just received the company's sales budget for the first quarter. January February March April May June 5,000 9,750 8,750 7,250 23,000 20,000 Company policy requires an ending finished goods inventory each month that will meet 5% of the following month's sales volume. Joshua plans to have 1,400 finished bricks at a cost of $12,250 in inventory at the beginning of the year. Prepare Coronado & Hill's production budget for the first...
11) how many units must be produced to also meet the 7000 units required in ending...
11) how many units must be produced to also meet the 7000 units required in ending inventory. ( this is managerial accounting) 2) Sunrise Poles manufactures hiking poles and is planning on producing 4,000 units in March and 3,700 in April. Each pole requires a half pound of material, which costs $1.20 per pound. The company’s policy is to have enough material on hand to equal 10% of the next month’s production needs and to maintain a finished goods inventory...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT