Questions
Wesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular...

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 $36. Wesley expects the following unit sales:

January 2,800
February 3,000
March 3,500
April 3,300
May 2,700


Wesley’s ending finished goods inventory policy is 20 percent of the next month’s sales.
       Suppose each handisaw takes approximately .75 hours to manufacture, and Wesley pays an average labor wage of $26 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 25 percent of the following month’s production requirements. Materials other than the housing unit total $4.50 per handisaw.
       Manufacturing overhead for this product includes $72,000 annual fixed overhead (based on production of 27,000 units) and $1.20 per unit variable manufacturing overhead. Wesley’s selling expenses are 7 percent of sales dollars, and administrative expenses are fixed at $18,000 per month.

Required:
1.
Compute the following for the first quarter

January February March 1st Quarter total
1. Budgeted Sales Revenue $100,800 $108,000 $126,000 $334,800
2. Budgeted Production in Units 2,840 3,100 3,460 9,400
3. Budgeted Cost of Raw Material Purchases for the Plastic Housings $0
4. Budgeted Direct Labor Cost $55,380 $60,450 $67,470 $183,300

In: Accounting

Wesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular...

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 $36. Wesley expects the following unit sales:

January 2,800
February 3,000
March 3,500
April 3,300
May 2,700


Wesley’s ending finished goods inventory policy is 20 percent of the next month’s sales.
       Suppose each handisaw takes approximately .75 hours to manufacture, and Wesley pays an average labor wage of $26 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 25 percent of the following month’s production requirements. Materials other than the housing unit total $4.50 per handisaw.
       Manufacturing overhead for this product includes $72,000 annual fixed overhead (based on production of 27,000 units) and $1.20 per unit variable manufacturing overhead. Wesley’s selling expenses are 7 percent of sales dollars, and administrative expenses are fixed at $18,000 per month.

Required:
1.
Compute the following for the first quarter

January February March 1st Quarter total
1. Budgeted Sales Revenue $100,800 $108,000 $126,000 $334,800
2. Budgeted Production in Units 2,840 3,100 3,460 9,400
3. Budgeted Cost of Raw Material Purchases for the Plastic Housings 22330 $0
4. Budgeted Direct Labor Cost $55,380 $60,450 $67,470 $183,300

In: Accounting

Wesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular...

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 $44. Wesley expects the following unit sales:

January 3,600
February 3,800
March 4,300
April 4,100
May 3,500


Wesley’s ending finished goods inventory policy is 30 percent of the next month’s sales.
       Suppose each handisaw takes approximately .60 hours to manufacture, and Wesley pays an average labor wage of $20 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 20 percent of the following month’s production requirements. Materials other than the housing unit total $4.50 per handisaw.
       Manufacturing overhead for this product includes $72,000 annual fixed overhead (based on production of 27,000 units) and $1.20 per unit variable manufacturing overhead. Wesley’s selling expenses are 7 percent of sales dollars, and administrative expenses are fixed at $18,000 per month.

Required:
1.
Compute the following for the first quarter: (Do not round your intermediate calculations.)

January February March 1st Quarter total
1. Budgeted Sales Revenue $0
2. Budgeted Production in Units 0
3. Budgeted Cost of Raw Material Purchases for the Plastic Housings $0
4. Budgeted Direct Labor Cost $0

In: Accounting

Wesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular...

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 $52. Wesley expects the following unit sales:

January 4,400
February 4,600
March 5,100
April 4,900
May 4,300


Wesley’s ending finished goods inventory policy is 25 percent of the next month’s sales.
       Suppose each handisaw takes approximately .60 hours to manufacture, and Wesley pays an average labor wage of $28 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 20 percent of the following month’s production requirements. Materials other than the housing unit total $4.50 per handisaw.
       Manufacturing overhead for this product includes $72,000 annual fixed overhead (based on production of 27,000 units) and $1.20 per unit variable manufacturing overhead. Wesley’s selling expenses are 7 percent of sales dollars, and administrative expenses are fixed at $18,000 per month.

Required:
1.
Compute the following for the first quarter: (Do not round your intermediate calculations.)

January February March 1st Quarter total
1. Budgeted Sales Revenue $228,800 $239,200 $265,200 $733,200
2. Budgeted Production in Units 4,450 4,725 5,050 14,225
3. Budgeted Cost of Raw Material Purchases for the Plastic Housings $0
4. Budgeted Direct Labor Cost $0

In: Accounting

Wesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular...

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 $46. Wesley expects the following unit sales:

January 3,800
February 4,000
March 4,500
April 4,300
May 3,700


Wesley’s ending finished goods inventory policy is 25 percent of the next month’s sales.

Suppose each handisaw takes approximately 0.60 hours to manufacture, and Wesley pays an average labor wage of $22 per hour.

Each handisaw requires a plastic housing that Wesley purchases from a supplier at a cost of $5.00 each. The company has an ending direct materials inventory policy of 20 percent of the following month’s production requirements. Materials other than the housing unit total $4.50 per handisaw.

Manufacturing overhead for this product includes $72,000 annual fixed overhead (based on production of 27,000 units) and $1.20 per unit variable manufacturing overhead. Wesley’s selling expenses are 7 percent of sales dollars, and administrative expenses are fixed at $18,000 per month.

Required:
Compute the following for the first quarter: (Round your intermediate calculations to nearest whole dollar.)

January February March 1st Quarter total
1. Budgeted Sales Revenue $0
2. Budgeted Production in Units 0
3. Budgeted Cost of Direct Materials Purchases for the Plastic Housings $0
4. Budgeted Direct Labor Cost $0

In: Accounting

Santana Rey expects second-quarter 2020 sales of Business Solutions’s line of computer furniture to be the...

Santana Rey expects second-quarter 2020 sales of Business Solutions’s line of computer furniture to be the same as the first quarter’s sales (reported below) without any changes in strategy. Monthly sales averaged 39 desk units (sales price of $1,200) and 15 chairs (sales price of $450).

BUSINESS SOLUTIONS—Computer Furniture Segment
Segment Income Statement*
For Quarter Ended March 31, 2020
Sales $ 160,650
Cost of goods sold 119,400
Gross profit 41,250
Expenses
Sales commissions (10%) 16,065
Advertising expenses 7,500
Other fixed expenses 16,500
Total expenses 40,065
Net income $ 1,185


* Reflects revenue and expense activity only related to the computer furniture segment.
† Revenue: (117 desks × $1,200) + (45 chairs × $450) = $140,400 + $20,250 = $160,650
‡ Cost of goods sold: (117 desks × $700) + (45 chairs × $200) + $28,500 = $119,400

Santana Rey believes that sales will increase each month for the next three months (April, 47 desks, 27 chairs; May, 51 desks, 30 chairs; June, 55 desks, 33 chairs) if selling prices are reduced to $1,080 for desks and $400 for chairs and advertising expenses are increased by 10% and remain at that level for all three months. The products’ variable cost will remain at $700 for desks and $200 for chairs. The sales staff will continue to earn a 10% commission, the fixed manufacturing costs per month will remain at $9,500 and other fixed expenses will remain at $5,500 per month.

Required:
1. Prepare budgeted income statements for the computer furniture segment for each of the months of April, May, and June that show the expected results from implementing the proposed changes. Use a three-column format, with one column for each month.
2. Recommend whether Santana should implement the proposed changes. Hint: Compare quarterly income for the proposed April-May-June period to the quarterly income for the January-February-March period.

In: Accounting

David Ricardo was the first economist to elaborate the theory of comparative advantage in his book...

David Ricardo was the first economist to elaborate the theory of comparative advantage in his book On the Principles of Political Economy and Taxation. Ricardo wrote:

Under a system of perfectly free commerce, each country naturally devotes its capital and labour to such employments as are most beneficial to each. This pursuit of individual advantage is admirably connected with the universal good of the whole . . . It is this principle, which determines that wine shall be made in France and Portugal, that corn shall be grown in America and Poland, and that hardware and other goods shall be manufactured in England. (1817, p. 188)

Read more at On the Principles of Political Economy and Taxation

Think about the 10-year historical period of 2000-2010. Identify trade policies of the time and discuss the following points:

  • What are the main goods and services the United States traded internationally?
  • What trade barriers were in place during that decade?
  • What are two pros and two cons of the trade barriers used?

In: Economics

1970s David Ricardo was the first economist to elaborate the theory of comparative advantage in his...


1970s

David Ricardo was the first economist to elaborate the theory of comparative advantage in his book On the Principles of Political Economy and Taxation. Ricardo wrote:

Under a system of perfectly free commerce, each country naturally devotes its capital and labour to such employments as are most beneficial to each. This pursuit of individual advantage is admirably connected with the universal good of the whole . . . It is this principle, which determines that wine shall be made in France and Portugal, that corn shall be grown in America and Poland, and that hardware and other goods shall be manufactured in England. (1817, p. 188)

Read more at On the Principles of Political Economy and Taxation

Think about the 10-year historical period you chose for your final project. Identify trade policies of the time and discuss the following points:

What are the main goods and services the United States traded internationally?
What trade barriers were in place during that decade?
What are two pros and two cons of the trade barriers used?

In: Economics

Exercise 22-13 a-b (Video) Crane Company has accumulated the following budget data for the year 2020....

Exercise 22-13 a-b (Video)

Crane Company has accumulated the following budget data for the year 2020.
1. Sales: 31,190 units, unit selling price $90.
2. Cost of one unit of finished goods: direct materials 1 pound at $5 per pound, direct labor 3 hours at $12 per hour, and manufacturing overhead $6 per direct labor hour.
3. Inventories (raw materials only): beginning, 10,180 pounds; ending, 15,410 pounds.
4. Selling and administrative expenses: $170,000; interest expense: $30,000.
5. Income taxes: 30% of income before income taxes.
Prepare a schedule showing the computation of cost of goods sold for 2020.
CRANE COMPANY
Computation of Cost of Goods Sold

For the Quarter Ending December 31, 2020For the Year Ending December 31, 2020December 31, 2020

Cost of one unit of finished goods:
    Direct materials $
    Direct labor
    Manufacturing overhead
          Total $
Cost of Goods Sold $
Prepare a budgeted multiple-step income statement for 2020.
CRANE COMPANY
Budgeted Income Statement

December 31, 2020For the Quarter Ending December 31, 2020For the Year Ending December 31, 2020

Cost of Goods SoldTotal Operating ExpensesIncome from OperationsIncome Tax ExpenseBeginning InventorySalesNet Income / (Loss)Ending InventoryGross ProfitIncome before Income TaxesOperating ExpensesPurchasesSelling and Administrative Expenses

$

PurchasesOperating ExpensesBeginning InventoryNet Income / (Loss)SalesIncome Tax ExpenseSelling and Administrative ExpensesTotal Operating ExpensesEnding InventoryCost of Goods SoldIncome before Income TaxesGross ProfitIncome from Operations

Ending InventoryGross ProfitOperating ExpensesNet Income / (Loss)Beginning InventoryTotal Operating ExpensesPurchasesSalesCost of Goods SoldIncome before Income TaxesSelling and Administrative ExpensesIncome from OperationsIncome Tax Expense

Ending InventoryIncome before Income TaxesPurchasesBeginning InventoryNet Income / (Loss)Total Operating ExpensesGross ProfitCost of Goods SoldSalesIncome from OperationsSelling and Administrative ExpensesIncome Tax ExpenseOperating Expenses

Beginning InventoryTotal Operating ExpensesNet Income / (Loss)Income from OperationsIncome Tax ExpenseOperating ExpensesSelling and Administrative ExpensesIncome before Income TaxesSalesCost of Goods SoldPurchasesEnding InventoryGross Profit

Income Tax ExpenseIncome before Income TaxesInterest ExpenseTotal Operating ExpensesNet Income / (Loss)Cost of Goods SoldPurchasesEnding InventorySalesSelling and Administrative ExpensesBeginning InventoryGross ProfitIncome from Operations

Income from OperationsTotal Operating ExpensesBeginning InventoryNet Income / (Loss)Income before Income TaxesIncome Tax ExpenseCost of Goods SoldGross ProfitOperating ExpensesPurchasesEnding InventorySalesSelling and Administrative Expenses

PurchasesTotal Operating ExpensesIncome from OperationsSalesIncome before Income TaxesSelling and Administrative ExpensesOperating ExpensesBeginning InventoryCost of Goods SoldEnding InventoryIncome Tax ExpenseNet Income / (Loss)Gross Profit

PurchasesIncome from OperationsSalesTotal Operating ExpensesGross ProfitNet Income / (Loss)Income Tax ExpenseBeginning InventoryCost of Goods SoldEnding InventoryIncome before Income TaxesOperating ExpensesSelling and Administrative Expenses

$

In: Accounting

The company sells a single product at a price of $60 per unit. The estimated sales...

The company sells a single product at a price of $60 per unit. The estimated sales volume for the next six months is as follows:

September October . . November December January . . February. .

13,000 units 12,000 units 14,000 units 20,000 units

9,000 units 10,000 units

All sales are on account. The company’s collection experience has been
that 32% of a month’s sales are collected in the month of sale, 64% are collected in the month following the sale, and 4% are uncollectible. It is expected that the net realizable value of accounts receivable (i.e., accounts receivable less allow- ance for uncollectible accounts) will be $499,200 on September 30, 2013. Management’s policy is to maintain ending finished goods inventory each month at a level equal to 40% of the next month’s budgeted sales. The fin- ished goods inventory on September 30, 2013, is expected to be 4,800 units. To make one unit of finished product, 5 pounds of materials are required. Management’s policy is to have enough materials on hand at the end of each month to equal 30% of the next month’s estimated usage. The raw materials inventory is expected to be 19,200 pounds on September 30, 2013.
The cost per pound of raw material is $4, and 70% of all purchases are paid for in the month of purchase; the remainder is paid in the following month. The accounts payable for raw material purchases is expected to be $75,960 on September 30, 2013.

Required:

  1. Prepare a sales budget in units and dollars, by month and in total, for the fourth quarter (October, November, and December) of 2013.

  2. Prepare a schedule of cash collections from sales, by month and in total, for the fourth quarter of 2013.

  3. Prepare a production budget in units, by month and in total, for the fourth quarter of 2013.

  4. Prepare a materials purchases budget in pounds, by month and in total, for the fourth quarter of 2013.

  5. Prepare a schedule of cash payments for materials, by month and in total, for the fourth quarter of 2013.

a.  Sales Budget Quarter Ended December 31, 2013
September October November December Total January February
Expected sales in units: 13,000 12,000 14,000 20,000
46,000
9,000 10,000
Selling price per unit: $60 $60 $60 $60 $60
Total Sales: $780,000 $720,000 $840,000 $1,200,000 $2,760,000
b.  Cash Collections from: Quarter Ended December 31, 2013
Sales % Collected October November December Total
September sales: $780,000 64% Collected $499,200 $499,200
October sales: $720,000 32% Collected 230,400 230,400
October sales: $720,000 32% Collected 460,800 460,800
November sales: $840,000 0% Collected 268,800 268,800
November sales: $840,000 0% Collected 537,600 537,600
December sales: $1,200,000 0% Collected 384,000 384,000
Total cash collections: $729,600 $729,600 $921,600 $2,380,800
c.  Production Budget Quarter Ended December 31, 2013
Finished Goods % Budgeted October November December Total January
Beginning Inventory: 4,800 5,600 8,000 4,800 3,600
Units to be produced: 12,800 16,400 15,600 44,800
9,400
Goods available for sale: 17,600 22,000 23,600 49,600 13,000
Desired ending inventory: 40% Budgeted 5,600 8,000 3,600 3,600 4,000
Quantity of goods sold: 12,000 14,000 20,000 46,000 9,000
d.  Materials Purchases Budget October November December Total January
Units to be produced: 12,800 16,400 15,600 44,800 9,400
Pounds required for each unit: 5
Total pounds used in production: 64,000 82,000 78,000
224,000
47,000
Quarter Ended December 31, 2013
Raw Materials % Budgeted October November December Total
Beginning Inventory: 19,200 24,600 23,400 19,200
Purchases of materials: 69,400 80,800 68,700 218,900
Materials available for use: 88,600 105,400 92,100 238,100
Desired ending inventory: 30% Budgeted 24,600 23,400 14,100 14,100
Total pounds used in production: 64,000 82,000 78,000 224,000
e.  Cash Payments for: October November December Total
Purchases of materials: 69,400 80,800 68,700 218,900
Cost per pound of raw material: $4.00
Total cost of raw material purchases: $277,600 $323,200 $192,360 $869,120
Quarter Ended December 31, 2013
Purchases % Paid October November December Total
September Net A/P: $75,960 $75,960
October purchases: $277,600 70% Paid 194,320 194,320
October purchases: $277,600 70% Paid 83,280 83,280
November purchases: $323,200 0% Paid 226,240 226,240
November purchases: $323,200 0% Paid 96,960 96,960
December purchases: $192,360 0% Paid 192,360 192,360
Total cash payments: $270,280 $309,520 $289,320 $869,120

This is the main question I'm having trouble with

Question

a

Assume that Freese, Inc. decided that because of strong economic conditions in general, a 10% increase in the
expected number of units to be sold each month was realistic.  Explain the effect, in general, on each of the budgets
presented of a 10% increase in the number of units sold.

b

Assuming that the number of units sold would not change, explain the effect on the budgets presented of a 5%
increase in the selling price of the product.  How does this price change effect differ from the sales volume
effect you described above?

c

The purchasing manager is evaluating an alternative supplier that would provide a slightly lower grade of raw
material at a savings from the current price of $4 per pound.  The new price would be at $3.50 per pound but
the product would now require six pounds of the lower grade of raw material to produce the same number of
good finished units as currently achieved.  Would you recommend the change to the new supplier?  What if the
new price was to be $3.00?  How about a price of $3.285307?  Explain your answers.

In: Accounting