Homework Answers
a) Production Budget in units is shown as follows:-
| June | July | August | September | |
| Budgeted unit sales | 90,000 | 120,000 | 210,000 | 150,000 |
| Add: Desired ending finished goods inventory (20% of next month sales) | 24,000 (120,000*20%) | 42,000 (210,000*20%) | 30,000 (150,000*20%) | 36,000 (180,000*20%) |
| Less: Beginning finished goods inventory | 30,000 | 24,000 | 42,000 | 30,000 |
| Budgeted units produced | 84,000 | 138,000 | 198,000 | 156,000 |
Therefore the units to be produced for July and August are 138,000 and 198,000 units respectively.
b) Direct Material Usage Budget is shown as follows:-
| June | July | August | September | |
| Budgeted unit produced (A) | 84,000 | 138,000 | 198,000 | 156,000 |
| Pounds of material required per unit (B) | 5 | 5 | 5 | 5 |
| Direct Materials needs (in pounds) (C = A*B) | 420,000 | 690,000 | 990,000 | 780,000 |
Therefore the total pounds of material required for July and August is 690,000 and 990,000 pounds respectively.
c) Direct Material Purchases Budget (Amounts in $)
| July | August | |
| Direct Material needs (in pounds) | 690,000 | 990,000 |
| Add: Desired ending material inventory (30% of next month needs) |
297,000 (990,000 pounds*30%) |
234,000 (780,000 pounds*30%) |
| Less: Beginning material inventory (30% of current month needs) |
207,000 (690,000 pounds*30%) |
297,000 |
| Direct material purchases budget (in pounds) (i) | 780,000 | 927,000 |
| Cost per pound (ii) | $9 | $10 |
| Direct material purchases budget (in $) (i*ii) | 7,020,000 | 9,270,000 |
Add Answer to:
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July...
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July...
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of material costs $8 in June,...
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July...
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of material costs $8 in June,...
Lubriderm Corp. 01. Lubriderm Corporation has the following budgeted unit sales for the next six- month...
Lubriderm Corp.
01. Lubriderm Corporation has the following budgeted unit sales for the next six- month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of material...
Problem 3 (10 points) Lubriderm Corporation has the following budgeted sales for the next six-month period:...
Problem 3 (10 points) Lubriderm Corporation has the following budgeted sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of material costs...
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month Unit Sales...
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month Unit Sales June 30,000 July 40,000 August 20,000 September 30,000 October 40,000 November 30,000 There were 9,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 30% of the unit sales for the next month. Four pounds of materials are required for each unit produced. Each pound of material costs $10. Raw material...
1. Operating Budgets (50 points) Lubriderm Corporation has the following budgeted unit sales for the next...
1. Operating Budgets (50 points) Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of...
1. Operating Budgets (50 points) Lubriderm Corporation has the following budgeted unit sales for the next...
1. Operating Budgets (50 points) Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of...
Osage Inc. has actual sales for May and June and forecast sales for July August September,...
Osage Inc. has actual sales for May and June and forecast sales for July August September, and October as follows: 5,910 units 6,280 units Actual: May June Forecast: July August September October 5,970 units 6,840 units 5,580 units 5,330 units Required: a. The firm's policy is to have finished goods Inventory on hand at the end of the month that is equal to 75% of the next month's sales. It is currently estimated that there will be 4,478 units on...
X-Tel budgets sales of $60,000 for April, $120,000 for May, and $85,000 for June. In addition, sales are 50% cas...
X-Tel budgets sales of $60,000 for April, $120,000 for May, and $85,000 for June. In addition, sales are 50% cash and 50% on credit. All credit sales are collected in the month following the sale. The April 1 balance in accounts receivable is $18,000. Prepare a schedule of budgeted cash receipts for April, May, and June May June X-TEL Cash Receipts Budget For April, May, and June April Sales Less: Ending accounts receivable Cash receipts from: Cash sales Collections of...
Required information Ramos Co. provides the following sales forecast and production budget for the next four...
Required information Ramos Co. provides the following sales forecast and production budget for the next four months: Sales (units) Budgeted production (units) April May June July 530 610 560 630 470 600 570 570 The company plans for finished goods inventory of 150 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month's production needs....
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of material costs $8 in June,...
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of material costs $8 in June,...
Lubriderm Corp.
01. Lubriderm Corporation has the following budgeted unit sales for the next six- month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of material...
Problem 3 (10 points) Lubriderm Corporation has the following budgeted sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of material costs...
1. Operating Budgets (50 points) Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of...
1. Operating Budgets (50 points) Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of...
Osage Inc. has actual sales for May and June and forecast sales for July August September, and October as follows: 5,910 units 6,280 units Actual: May June Forecast: July August September October 5,970 units 6,840 units 5,580 units 5,330 units Required: a. The firm's policy is to have finished goods Inventory on hand at the end of the month that is equal to 75% of the next month's sales. It is currently estimated that there will be 4,478 units on...
X-Tel budgets sales of $60,000 for April, $120,000 for May, and $85,000 for June. In addition, sales are 50% cash and 50% on credit. All credit sales are collected in the month following the sale. The April 1 balance in accounts receivable is $18,000. Prepare a schedule of budgeted cash receipts for April, May, and June May June X-TEL Cash Receipts Budget For April, May, and June April Sales Less: Ending accounts receivable Cash receipts from: Cash sales Collections of...
Required information Ramos Co. provides the following sales forecast and production budget for the next four months: Sales (units) Budgeted production (units) April May June July 530 610 560 630 470 600 570 570 The company plans for finished goods inventory of 150 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month's production needs....
Most questions answered within 3 hours.
-
Now that this course has taken you on a journey of introduction
to the world of...
asked 26 minutes ago -
Given a regression sum of squares equal to 2373.59 and a total
sum of squares equal...
asked 40 minutes ago -
The sandwich maker of the EE-Cole-Eye Sandwich Truck was just
fired (for a reason described below)...
asked 2 hours ago -
Name the following coordination compounds using systematic
nomenclature.
1. [Co(H2O)6]Cl2:
2. [Cr(NH3)6](NO3)3:
3. K4[Fe(CN)6]:
4. Na[Au(CN)4]:...
asked 2 hours ago -
Propose an efficient synthesis of 2-Bromo-5-nitrotoluene from
benzene. Hint: 3 steps. Consider directing effects of substituents....
asked 4 hours ago -
This assignment will explore the impact of corporate decisions
on a local versus a global perspective....
asked 3 hours ago -
Given the function below, F(w,x,y,z)= x’z+w’z’+w’y
a) draw a logic diagram for an implementation which uses...
asked 3 hours ago -
Most political philosophers believe we have a duty to obey laws,
even if the laws in...
asked 4 hours ago -
Which of the following are common negotiation outcome
mistakes?
a. Leave money on the table b....
asked 4 hours ago -
Convert the following quantities:
a) 0.819 atm to torr b) 512 mmHg to bar c) 11.2...
asked 4 hours ago -
C ++ Implement cat command
The purpose of this assignment is to provide practice using the...
asked 4 hours ago -
we
convert sugars into another form of stored potential energy. This
is called?
asked 5 hours ago