| Requirement 2: |
|
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: |
| Data |
Year 2 Quarter |
Year 3 Quarter |
||||
| 1 | 2 | 3 | 4 | 1 | 2 | |
| Budgeted unit sales | 50,000 | 65,000 | 105,000 | 60,000 | 85,000 | 95,000 |
| Selling price per unit | $7 | per unit | ||||
| Chapter 7: Applying Excel | |||||||
| 2 | |||||||
| 3 | Data | Year 2 Quarter | Year 3 Quarter | ||||
| 4 | 1 | 2 | 3 | 4 | 1 | 2 | |
| 5 | Budgeted unit sales | 50,000 | 65,000 | 105,000 | 60,000 | 85,000 | 95,000 |
| 6 | |||||||
| 7 | • Selling price per unit | $8 | per unit | ||||
| 8 | • Accounts receivable, beginning balance | $65,000 | |||||
| 9 | • Sales collected in the quarter sales are made | 75% | |||||
| 10 | • Sales collected in the quarter after sales are made | 25% | |||||
| 11 | • Desired ending finished goods inventory is | 30% | of the budgeted unit sales of the next quarter | ||||
| 12 | • Finished goods inventory, beginning | 12,000 | units | ||||
| 13 | • Raw materials required to produce one unit | 5 | pounds | ||||
| 14 | • Desired ending inventory of raw materials is | 10% | of the next quarter's production needs | ||||
| 15 | • Raw materials inventory, beginning | 23,000 | pounds | ||||
| 16 | • Raw material costs | $0.80 | per pound | ||||
| 17 | • Raw materials purchases are paid | 60% | in the quarter the purchases are made | ||||
| 18 | and | 40% | in the quarter following purchase | ||||
| 19 | • Accounts payable for raw materials, beginning balance | $81,500 | |||||
| 20 | |
||||||
| a. |
What are the total expected cash collections for the year under this revised budget? |
| b. |
What is the total required production for the year under this revised budget? |
| c. |
What is the total cost of raw materials to be purchased for the year under this revised budget? |
| d. |
What are the total expected cash disbursements for raw materials for the year under this revised budget? |
| e. |
After seeing this revised budget, the production manager cautioned that due to the current production constraint, a complex milling machine, the plant can produce no more than 80,000 units in any one quarter. Is this a potential problem? |
||||
|
In: Accounting
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget:
| Data |
Year 2 Quarter |
Year 3 Quarter |
||||
| 1 | 2 | 3 | 4 | 1 | 2 | |
| Budgeted unit sales | 45,000 | 70,000 | 110,000 | 75,000 | 90,000 | 95,000 |
| Selling price per unit | $7 | per unit | ||||
|
A |
B |
C |
D |
E |
F |
F |
|
| 1 | Chapter 7: Applying Excel | ||||||
| 2 | |||||||
| 3 | Data | Year 2 Quarter | Year 3 Quarter | ||||
| 4 | 1 | 2 | 3 | 4 | 1 | 2 | |
| 5 | Budgeted unit sales | 45,000 | 70,000 | 110,000 | 75,000 | 90,000 | 95,000 |
| 6 | |||||||
| 7 | • Selling price per unit | $8 | per unit | ||||
| 8 | • Accounts receivable, beginning balance | $65,000 | |||||
| 9 | • Sales collected in the quarter sales are made | 75% | |||||
| 10 | • Sales collected in the quarter after sales are made | 25% | |||||
| 11 | • Desired ending finished goods inventory is | 30% | of the budgeted unit sales of the next quarter | ||||
| 12 | • Finished goods inventory, beginning | 12,000 | units | ||||
| 13 | • Raw materials required to produce one unit | 5 | pounds | ||||
| 14 | • Desired ending inventory of raw materials is | 10% | of the next quarter's production needs | ||||
| 15 | • Raw materials inventory, beginning | 23,000 | pounds | ||||
| 16 | • Raw material costs | $0.80 | per pound | ||||
| 17 | • Raw materials purchases are paid | 60% | in the quarter the purchases are made | ||||
| 18 | and | 40% | in the quarter following purchase | ||||
| 19 | • Accounts payable for raw materials, beginning balance | $81,500 | |||||
| 20 | |||||||
| a. |
What are the total expected cash collections for the year under this revised budget? |
| b. |
What is the total required production for the year under this revised budget? |
| c. |
What is the total cost of raw materials to be purchased for the year under this revised budget? |
| d. |
What are the total expected cash disbursements for raw materials for the year under this revised budget? |
| e. |
After seeing this revised budget, the production manager cautioned that due to the current production constraint, a complex milling machine, the plant can produce no more than 80,000 units in any one quarter. Is this a potential problem? |
||||
|
In: Accounting
| Requirement 2: |
|
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: |
| Data |
Year 2 Quarter |
Year 3 Quarter |
||||
| 1 | 2 | 3 | 4 | 1 | 2 | |
| Budgeted unit sales | 45,000 | 65,000 | 105,000 | 70,000 | 85,000 | 90,000 |
| Selling price per unit | $7 | per unit | ||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| a. |
What are the total expected cash collections for the year under this revised budget? |
| b. |
What is the total required production for the year under this revised budget? |
| c. |
What is the total cost of raw materials to be purchased for the year under this revised budget? |
| d. |
What are the total expected cash disbursements for raw materials for the year under this revised budget? |
| e. |
After seeing this revised budget, the production manager cautioned that due to the current production constraint, a complex milling machine, the plant can produce no more than 80,000 units in any one quarter. Is this a potential problem? |
||||
|
In: Accounting
Requirement 2:
The company has just hired a new marketing manager who insists that
unit sales can be dramatically increased by dropping the selling
price from $8 to $7. The marketing manager would like to use the
following projections in the budget:
| Data | Year 2 Quarter | Year 3 Quarter | ||||
| 1 | 2 | 3 | 4 | 1 | 2 | |
| Budgeted unit sales | 45,000 | 70,000 | 110,000 | 65,000 | 80,000 | 95,000 |
| Selling price per unit | $7 | per unit | ||||
|
A
|
B
|
C
|
D
|
E
|
F
|
F
|
|
| 1 | Chapter 9: Applying Excel | ||||||
| 2 | |||||||
| 3 | Data | Year 2 Quarter | Year 3 Quarter | ||||
| 4 | 1 | 2 | 3 | 4 | 1 | 2 | |
| 5 | Budgeted unit sales | 45,000 | 70,000 | 110,000 | 65,000 | 80,000 | 95,000 |
| 6 | |||||||
| 7 | • Selling price per unit | $7 | per unit | ||||
| 8 | • Accounts receivable, beginning balance | $65,000 | |||||
| 9 | • Sales collected in the quarter sales are made | 75% | |||||
| 10 | • Sales collected in the quarter after sales are made | 25% | |||||
| 11 | • Desired ending finished goods inventory is | 30% | of the budgeted unit sales of the next quarter | ||||
| 12 | • Finished goods inventory, beginning | 12,000 | units | ||||
| 13 | • Raw materials required to produce one unit | 5 | pounds | ||||
| 14 | • Desired ending inventory of raw materials is | 10% | of the next quarter's production needs | ||||
| 15 | • Raw materials inventory, beginning | 23,000 | pounds | ||||
| 16 | • Raw material costs | $0.80 | per pound | ||||
| 17 | • Raw materials purchases are paid | 60% | in the quarter the purchases are made | ||||
| 18 | and | 40% | in the quarter following purchase | ||||
| 19 | • Accounts payable for raw materials, beginning balance | $81,500 | |||||
| 20 | |||||||
\
a. What are the total expected cash collections for the year under this revised budget?
b. What is the total required production for the year under this revised budget?
c. What is the total cost of raw materials to be purchased for the year under this revised budget?
d. What are the total expected cash disbursements for raw materials for the year under this revised budget?
e. After seeing this revised budget, the production manager cautioned that due to the limited availability of a complex milling machine, the plant can produce no more than 80,000 units in any one quarter. Is this a potential problem?
In: Accounting
Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South East Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company’s products. The company now is planning raw materials needs for the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements:
The finished goods inventory on hand at the end of each month must equal 2,000 units of Supermix plus 20% of the next month’s sales. The finished goods inventory on June 30 is budgeted to be 10,600 units.
The raw materials inventory on hand at the end of each month must equal one-half of the following month’s production needs for raw materials. The raw materials inventory on June 30 is budgeted to be 66,000 cc of solvent H300.
The company maintains no work in process inventories.
A monthly sales budget for Supermix for the third and fourth quarters of the year follows.
| Budgeted Unit Sales | |
| July | 43,000 |
| August | 48,000 |
| September | 58,000 |
| October | 38,000 |
| November | 28,000 |
| December | 18,000 |
Required:
1. Prepare a production budget for Supermix for the months July, August, September, and October.
3. Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter in total.
Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter in total.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
The sales budget for your company in the coming year is based on a quarterly growth rate of 10 percent with the first-quarter sales projection at $225.9 million. In addition to this basic trend, the seasonal adjustments for the four quarters are 0, −$16.9, −$8.9, and $21.9 million, respectively. Generally, 50 percent of the sales can be collected within the quarter and 45 percent in the following quarter; the rest of the sales are bad debt. The bad debts are written off in the second quarter after the sales are made. The beginning accounts receivable balance is $104.9 million. Assuming all sales are on credit, compute the cash collections from sales for each quarter. (Enter your answers in dollars, not millions of dollars, e.g., 1,234,567. Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.)
In: Finance
The sales budget for your company in the coming year is based on a quarterly growth rate of 10 percent with the first-quarter sales projection at $165 million. In addition to this basic trend, the seasonal adjustments for the four quarters are 0, −$12, −$6, and $18 million, respectively. Generally, 50 percent of the sales can be collected within the quarter and 45 percent in the following quarter; the rest of the sales are bad debt. The bad debts are written off in the second quarter after the sales are made. The beginning accounts receivable balance is $84 million. Assuming all sales are on credit, compute the cash collections from sales for each quarter. Enter your answers in dollars, not millions of dollars, e.g., 1,234,567. Do not round intermediate calculations and shows all the formula and steps.
In: Finance
Wesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular items is a cordless power handisaw. Each handisaw sells for $70. Wesley expects the following unit sales:
| January | 2,400 |
| February | 2,200 |
| March | 2,900 |
| April | 2,600 |
| May | 2,000 |
Wesley’s ending finished goods inventory policy is 35 percent of
the next month’s sales.
Suppose each handisaw takes
approximately .45 hours to manufacture, and Wesley pays an average
labor wage of $16.50 per hour.
Each handisaw requires a
plastic housing that Wesley purchases from a supplier at a cost of
$7.00 each. The company has an ending raw materials inventory
policy of 10 percent of the following month’s production
requirements. Materials other than the housing unit total $4.00 per
handisaw.
Manufacturing overhead for this
product includes $66,000 annual fixed overhead (based on production
of 24,000 units) and $.80 per unit variable manufacturing overhead.
Wesley’s selling expenses are 7 percent of sales dollars, and
administrative expenses are fixed at $16,000 per month.
Required:
2. Compute the budgeted selling and administrative
expenses.
|
3. Complete the budgeted income statement for the handisaw product for the first quarter. (Round direct material, direct labor and overhead costs per unit to 2 decimal places. Round final answers to the nearest dollar
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
amount.)
In: Accounting
Listed below are student evaluation ratings of courses, where a rating of 5 is for "excellent." The ratings were obtained at one university in a state. Construct a confidence interval using a 95% confidence level. What does the confidence interval tell about the population of all college students in the state? 3.8, 2.9, 3.9, 4.7, 2.9, 4.3, 3.6, 4.8, 4.6, 4.2, 4.1, 3.8, 3.2, 4.1, 3.8 What is the confidence interval for the population mean u?
In: Statistics and Probability
home / study / business / finance / finance questions and answers / question 11 the taxing and spending policies of the federal government designed to promote ...
Question: QUESTION 11 The taxing and spending policies of the Federal Government designed to promote nati...
Edit question
QUESTION 11
The taxing and spending policies of the Federal Government designed to promote national ecomomic goals are known as "fiscal policy."
True
False
3 points
QUESTION 12
Most states exempt their own municipal securities from their own state and local taxes.
True
False
3 points
QUESTION 13
Firm commitment underwriting is performed by an investment bank that has guaranteed the issuer a sum of money that will be raised by an Initial Public Offering
True
False
In: Finance