1 answer

Waterways Continuing Problem-10 (Part Level Submission) Waterways Corporation has recently acquired a small manufacturing operation in...

Question:

Waterways Continuing Problem-10 (Part Level Submission)

Waterways Corporation has recently acquired a small manufacturing operation in British Columbia that produces one of its more popular items. This plant will provide these units for resale in retail hardware stores in British Columbia and Alberta. Because the budget prepared by the plant was incomplete, Jordan Leigh, Waterways’ CFO, was sent to B.C. to oversee the plant’s budgeting process for the second quarter of 2017.

Jordan asked the various managers to collect the following information for preparing the second-quarter budget.

Sales
Unit sales for February 2017 100,000
Unit sales for March 2017 112,000
Expected unit sales for April 2017 120,000
Expected unit sales for May 2017 125,000
Expected unit sales for June 2017 130,000
Expected unit sales for July 2017 145,000
Expected unit sales for August 2017 170,000
Average unit selling price $13

Based on the experience from the home plant, Jordan has suggested that the B.C. plant keep 10% of the next month’s unit sales in ending inventory. The plant has contracts with some of the major home hardware giants, so all sales are on account; 50% of the accounts receivable is collected in the month of sale, and the balance is collected in the month after sale. This was the same collection pattern from the previous year. The new plant has no bad debts.

Direct Materials
The combined quantity of direct materials (consisting of metal, plastic and rubber) used in each unit is 1.20 kg. Metal, plastic, and rubber together amount to $1.50 per kg. Inventory of combined direct material on March 31 consisted of 14,460 kg.

This plant likes to keep 10% of the materials needed for the next month in its ending inventory. Fifty percent of the payables is paid in the month of purchase, and 50% is paid in the month after purchase.

Accounts Payable on March 31 will total $129,000.

Direct Labour
Labour requires 15 minutes per unit for completion and is paid at an average rate of $12 per hour.

Manufacturing Overhead
Indirect materials $0.70 per labour hour
Indirect labour $0.50 per labour hour
Utilities $0.40 per labour hour
Maintenance $0.30 per labour hour
Salaries $44,400 per month
Depreciation $14,000 per month
Property taxes $2,150 per month
Insurance $1,000 per month
Janitorial $2,600 per month
Selling and Administrative
Variable selling and administrative cost per unit is $1.50.
   Advertising $14,000 a month
   Depreciation $2,400 a month
   Insurance $1,100 a month
   Other fixed costs $3,400 a month
   Salaries $77,000 a month

Other Information
The Cash balance on March 31 will be $111,000, but Waterways has decided it would like to maintain a cash balance of at least $600,000 beginning on April 30. The company has an open line of credit with its bank. The terms of the agreement require borrowing to be in $1,000 increments at 3% interest. Borrowing is considered to be on the first day of the month and repayments are on the last day of the month. Assume interest is paid at the end of the quarter.

In May, $660,000 of new equipment to update operations will be purchased.

Three months’ insurance is prepaid on the first day of the first month of the quarter.

Question: Fill in the blank

For the second quarter of 2017, prepare a production budget. WATERWAYS CORPORATION British Columbia Production Plant Producti

For the second quarter of 2017, prepare a production budget. WATERWAYS CORPORATION British Columbia Production Plant Production Budget for the 2nd Quarter, 2017 April May Total

Answers

WATERWAYS CORPORATION
British Columbia Production Plant
Production Budget for the 2nd Quarter, 2017
April May June Total
Expected unit sales 120000 125000 130000 375000
Add: Desired ending inventory 12500 13000 14500 14500
Total needs 132500 138000 144500 389500
Less: Beginning inventory 12000 12500 13000 12000
Budgeted units to be produced 120500 125500 131500 377500

Note: Kindly select appropriately from the drop-downs since the same have not been provided with the question.

.

Similar Solved Questions

1 answer
Exercise 5-12 Multiproduct Break-Even Analysis (LO5-9) Olongapo Sports Corporation distributes two premium golf balls-Flight Dynamic and...
Exercise 5-12 Multiproduct Break-Even Analysis (LO5-9) Olongapo Sports Corporation distributes two premium golf balls-Flight Dynamic and Sure Shot. Monthly sales and the contribution margin ratios for the two products follow. Product Flight Dynamic Shot $ 700,000 $300,000 605 785 Total $1,000,000 CM...
1 answer
2- Refrigeration R134a Saturated liquid (x = 0) at temperature 20°C It was choked Adiabatic with...
2- Refrigeration R134a Saturated liquid (x = 0) at temperature 20°C It was choked Adiabatic with enthalpy constant) till temperature 0°C. Find the: - At the first point: P= h= At the second point:...
1 answer
Please help me on this. I dont require any worded explanations. Thanks! / Hg(OAC)2 H20, THE...
Please help me on this. I dont require any worded explanations. Thanks! / Hg(OAC)2 H20, THE NaBH4 NaOH 1. Hg(O2CCF3)2, POH 2. NaBH4, NaOH 1. BHz - THE 2. H2O2, HO R-OH + Nax - TsCI NaCN DMSO pyridine OH MSCI pyridine NasMe DMSO cat. HA MeOH + g Arrange in the Increasing acidity order H2O ROH RC=...
1 answer
Kyle has $18.20 in dimes and quarters. He has 14 more dimes than quarters. How many quarters does Kyle have?
Kyle has $18.20 in dimes and quarters. He has 14 more dimes than quarters. How many quarters does Kyle have?...
1 answer
Gabriel put $6000 in a 2-year CD paying 4% interest, compounded monthly After 2 years, he withdrew all his money. What was the amount of the withdrawal?
Gabriel put $6000 in a 2-year CD paying 4% interest, compounded monthly After 2 years, he withdrew all his money. What was the amount of the withdrawal?...
1 answer
A toroid with 3.0*10^5 turns per meter has 0.60m inner and 1.0m outer diameter and is...
A toroid with 3.0*10^5 turns per meter has 0.60m inner and 1.0m outer diameter and is powered with 15A of electric current. What is the magnetic field on a 0.80m diameter circle at the central plane of this toroid?...
1 answer
1. Using the method of joints, determine the internal force in each member of this truss....
1. Using the method of joints, determine the internal force in each member of this truss. 2 kips 1 kip 12 ft 12 ft - Reactions В 8 ft EFx=/= Rex {fy co = Rey Rey = 134 OIOIO E 6 ft 12 ft EM - ORE...
1 answer
Question 24 (4 points) Good Time Company is a regional chain department store. It will remain...
Question 24 (4 points) Good Time Company is a regional chain department store. It will remain in business for one more year. The probability of a boom year is 60 percent and the probability of a recession is 40 percent. It is projected that the company will generate a total cash flow of $250 million...
1 answer
1. (10 marks) A knee surgeon collected data on the post-operative hemoglobin levels (in g/dL) of...
1. (10 marks) A knee surgeon collected data on the post-operative hemoglobin levels (in g/dL) of 102 patients who had total knee replacements. He randomly assigned half of the patients to receive a closed suction drain and half to receive no drain. Of interest is whether post operative hemoglobin le...
1 answer
The following reaction has an activation energy of 262 kJ/mol. C, H 일)600.0 K the rate...
The following reaction has an activation energy of 262 kJ/mol. C, H 일)600.0 K the rate constant is 6.1x10-8 s-1. What is the value of the rate ca stant at 750.0 K? Number に111.72x 10-12 There is a hint available! View the hint by clicking on the Click on the divider bar again to hide t...
1 answer
Your answer is partially correct. Pearl Company purchased a computer system for $74,600 on January 1,...
Your answer is partially correct. Pearl Company purchased a computer system for $74,600 on January 1, 2019. It was depreciated based on a 7-year life and an $18,600 salvage value. On January 1, 2021, Pearl revised these estimates to a total useful life of 4 years and a salvage value of $9,100. Pearl...
1 answer
Zenith Corporation sells some of its used store fixtures. The acquisition cost of the fixtures is...
Zenith Corporation sells some of its used store fixtures. The acquisition cost of the fixtures is $12,120, and the accumulated depreciation on these fixtures is $7,802 at the time of sale. The fixtures are sold for $4,318. The value of this transaction in the investing section of the statement of ca...
1 answer
Write a program that will find the winner in a skating competition. It will have a...
Write a program that will find the winner in a skating competition. It will have a structure for skater information: name, country, points (array of 10 real numbers), and average. Program will input information of 5 skaters and will find and display the winner by calculating the average point of eac...
1 answer
How do you use the binomial series to expand #1/(1-x^2)^(1/2)#?
How do you use the binomial series to expand #1/(1-x^2)^(1/2)#?...
1 answer
Rate constant for decomposition of hydrogen peroxide is 7.0 x10-5  s-1at 300.0K, with activation energy of 75...
Rate constant for decomposition of hydrogen peroxide is 7.0 x10-5  s-1at 300.0K, with activation energy of 75 kJ/mol.  At what temperature would the reaction rate be doubled?...
1 answer
Convert the following measurement. 4 kg □×10 8.49 × 10 cm
Convert the following measurement. 4 kg □×10 8.49 × 10 cm...
1 answer
5. [-/7.14 Points) DETAILS SERCP11 27.5.P.028. MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER Speed of In...
5. [-/7.14 Points) DETAILS SERCP11 27.5.P.028. MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER Speed of In a Compton scattering experiment, an x-ray photon scatters through an angle of 17.0° from a free electron that is initially at rest. The electron recoils with a speed of 1,560 km/s. (a) Calculate...