Santana Rey expects second-quarter 2018 sales of her new line of computer furniture to be the same as the first quarter’s sales (reported below) without any changes in strategy. Monthly sales averaged 41 desk units (sales price of $1,260) and 21 chairs (sales price of $510).
Business Solution --Computer Furniture Segment | |
Segment Income Statement* | |
For Quarter Ended March 31, 2018 | |
Sales† | $187,110 |
Cost of goods sold‡ | 119,960 |
Gross Profit | 67,150 |
Expenses | |
Sales commissions (10%) | 18,711 |
Advertising expenses | 9,300 |
Other fixed expenses | 18,300 |
Total Expense | 46,311 |
Net Income | $20,839 |
Reflects revenue and expense activity only related to the
computer furniture segment.
† Revenue: (123 desks × $1,260) + (63 chairs × $510) = $154,980 +
$32,130 = $187,110
‡ Cost of goods sold: (123 desks × $760) + (63 chairs × $260) +
$30,300 = $119,960
Santana Rey believes that sales will increase each month for the
next three months (April, 49 desks, 33 chairs; May, 53 desks, 36
chairs; June, 57 desks, 39 chairs) if selling prices are reduced to
$1,160 for desks and $460 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 $760 for desks and $260 for
chairs. The sales staff will continue to earn a 10% commission, the
fixed manufacturing costs per month will remain at $10,100 and
other fixed expenses will remain at $6,100 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.
Business solution-- computer furniture segment | |||
Budgeted Income Statement | |||
For Months of April, May, and June | |||
April | May | June | |
Cost of goods sold | |||
Sales | |||
Gross profit | |||
Expense | |||
Sales commission | |||
Advertising | |||
Other fixed expenses | |||
Total expenses | |||
Net income (loss) |
2. Recommend whether Santana Rey should implement the proposed changes.
a). Should implement the proposed changes.
b). Should not implement the proposed changes.
1.
Business solution-- computer furniture segment |
|||
Budgeted Income Statement |
|||
For Months of April, May, and June |
|||
April |
May |
June |
|
Sales |
72,020 |
78,040 |
84,060 |
Cost of Goods Sold |
55,920 |
59,740 |
63,560 |
Gross profit |
16,100 |
18,300 |
20,500 |
Expense |
|||
Sales commission |
7,202 |
7,804 |
8,406 |
Advertising |
3,410 |
3,410 |
3,410 |
Other fixed expenses |
6,100 |
6,100 |
6,100 |
Total expenses |
16,712 |
17,314 |
17,916 |
Net income (loss) |
$(612) |
986 |
2,584 |
Note: Advertising Expense = 9,300/3 -= $3,100
increased by 10% = 3,410
Total profit for the quarter = $2,958
which is less than quarter 1 profit
2.Hence,
b). Should not implement the proposed changes.
Santana Rey expects second-quarter 2018 sales of her new line of computer furniture to be the sam...
Santana Rey expects second-quarter 2018 sales of her new line of computer furniture to be the same as the first quarter's sales (reported below) without any changes in strategy. Monthly sales averaged 44 desk units (sales price of $1320) and 27 chairs (sales price of $570) BUSINESS SOLUTIONS-Computer Furniture Segment Segment Income Statement For Quarter Ended March 31, 2018 Sales $220,410 Cost of goods solat 144,860 Gross profit 75,550 Expenses Sales Comissions (10) 22.00 Advertising expenses 11.100 Other Fixed expenses...
Santana Rey expects second quarter 2018 sales of her new line of computer furniture to be the same as the first quarter's sales (reported below) without any changes in strategy. Monthly sales averaged 43 desk units (sales price of $1.290) and 24 chairs (sales price of $540) BUSINESS SOLUTIONS--Computer Furniture Segment Segment Income Statement For Quarter Ended March 31, 2018 Sales $ 205,290 Cost of goods sold 133,190 Gross profit 72,100 Expenses Sales commissions (10%) 20,529 Advertising expenses 12.200 Other...
Santana Rey expects second-quarter 2018 sales of her new line of computer furniture to be the same as the first quarter's sales (reported below) without any changes in strategy. Monthly sales averaged 43 desk units (sales price of $1290) and 24 chairs (sales price of $540) BUSINESS SOLUTIONS Computer Furniture Segment Segment Income Statement For Quarter Ended March 31, 2018 Sales' $285,290 Cost of goods sold' 133,190 Gross profit 72,100 Expenses Sales commissions (lex) 20,529 Advertising expenses 10.200 Other Fixed...
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 38 desk units (sales price of $1,180) and 13 chairs (sales price of $430). BUSINESS SOLUTIONS-Computer Furniture Segment Segment Income Statement For Quarter Ended March 31, 2020 Sales $ 151,290 Cost of goods sold 112,440 Gross profit 38,850 Expenses Sales commissions (10%) 15,129 Advertising expenses 6,900 Other fixed...
Sales BUSTNESS SOLUTIONS Computer Furniture Segment Segment Income Statement For Quarter Ended March 31, 2018 $216,600 Cost of goods sold' 141,700 Gross profit 74,900 Expenses Sales commissions (10%) 21,660 Advertising expenses 10.800 Other fixed expenses 19,800 Total expenses 52,260 Net income $ 22,640 * Reflects revenue and expense activity only related to the computer furniture segment. Revenue: (132 desks * $1,310) + 78 chairs $560) = $172,920+ $43,680 = $216,600 1 Cost of goods sold: (132 desks * $810) +...
Help Seve & bet sales reported below without any changes in strategy. Monthly sales averaged 42 desk units sales price of $530). les price of $1280) and 23 chairs BUSINESS SOLUTIONS-Computer Furniture Suprant For traded 1.200 $197.50 148,500 Cost of goods sold Gross profit Expenses Sales sons (10) Other Total expenses ses 18. Reflects revenue and expense activity only related to the computer furniture segment Revenue 126 desks S280) 69 chairs $530-516120526570 7850 Cost of goods sold (126 desks $780)...
Just do part 1 June The chapter 22 team discussion problem is presented below. If your team has three members, complete part 1 only; each team member should prepare a budgeted income statement for a different month (April, May, or June). If your team has four members, complete parts 1 and 2; the first three team members will complete part 1 (April, May, and June, respectively), and the fourth team member will complete part 2. The problem is reproduced below....
Santana Rey expects sales of Business Solutions’s line of computer workstation furniture to equal 300 workstations (at a sales price of $3,000 each) for 2019. The workstations’ manufacturing costs include the following. Direct materials $ 800 per unit Direct labor $ 400 per unit Variable overhead $ 100 per unit Fixed overhead $ 24,000 per year The selling expenses related to these workstations follow. Variable selling expenses $ 50 per unit Fixed selling expenses $ 4,000 per year Santana is...
Santana Rey expects sales of Business Solutions's line of computer workstation furniture to equal 300 workstations (at a sales $3,500 each) for 2018. The workstations' manufacturing costs include the following Direct materials Direct labor Variable overhead Fixed overhead 770 per unit $ 300 per unit 5 60 per unit $28,880 per year The selling expenses related to these workstations follow Variable selling expenses Fixed selling expenses s 50 per unit $3,200 per year Santana is considering how many workstations to...
Santana Rey expects sales of Business Solutions's line of computer workstation furniture to equal 300 workstations (at a sales price of $3,700 each) for 2018. The workstations' manufacturing costs include the following Direct materials Direct labor Variable overhead Fixed overhead $780 per unit $ 350 per unit 70 per unit $19,200 per year The selling expenses related to these workstations follow Variable selling expenses Fixed selling expenses S40 per unit $3,500 per year Santana is considering how many workstations to...