Question

In: Accounting

Serial Problem Business Solutions P2, P3 Santana Rey expects sales of Business Solutions’s line of computer...

Serial Problem Business Solutions P2, P3

Santana Rey expects sales of Business Solutions’s line of computer workstation furniture to equal 300 workstations (at a sales price of $3,100 each) for 2018. The workstations’ manufacturing costs include the following.

Direct materials $740 per unit

Direct labor $360 per unit

Variable overhead $90 per unit

Fixed overhead $24,000 per year


The selling expenses related to these workstations follow

Variable selling expenses $ 35 per unit
Fixed selling expenses $ 3,900

per year

Santana is considering how many workstations to produce in 2018. She is confident that she will be able to sell any workstations in her 2018 ending inventory during 2019. However, Santana does not want to overproduce as she does not have sufficient storage space for many more workstations.

Required:
1. Complete the following income statements using absorption costing.
Production Volume Production Volume
COGS 300 Workstations 320 Workstations
Direct Materials Per Unit
Direct Labor Per Unit
Variable Overhead Per Unit
Fixed Overhead Per Unit
COGS Per Unit
Number of Workstations Sold
Total COGS
Business Solutions
Absorption Costing Income Statement
Production Volume Production Volume
Sales Volume- 320 Workstations 300 Workstations 320 Workstations
Sales
COGS
Gross Margin
Selling G&A Expenses
Net Income (Loss)
Business Solutions
Variable Costing Income Statement
Production Volume Units 300 Workstations 320 Workstations
Sales Volume Units 300 Workstations 300 Workstations
Sales
Less: Variable Costs
Direct Materials
Direct Labor
Variable Factory Overhead
Variable Selling Expense
Total Variable Costs
Contribution Margin
Less: Fixed Expenses
Fixed Overhead Costs
Fixed Selling Expense
Total Fixed Costs
Net Income (Loss)

Solutions

Expert Solution

1) COGS Amount :
Production volume Production volume
COGS 300 workstations 320 workstations
DM per unit 740 740
DL per unit 360 360
V OH per unit 90 90
F OH per unit 80 75
COGS per unit 1270 1265
Number of Workstations sold 300 300
Total COGS 381000 379500
2)Absorption costing income statement:
Production volume 300 workstations 320 workstations
Sales Volume 300 workstations 300 workstations
Sales   930000 930000
COGS 381000 379500
Gross Margin 549000 550500
Selling G&A Expenses 14400 14400
Net Income 534600 536100
3) Variable Costing Income Statement:
Production Volume units 300 workstations 320 workstations
Sales volume units 300 workstations 300 workstations
Sales   930000 930000
Less: Variable costs:
DM 222000 222000
DL 108000 108000
V F OH 27000 27000
V S Exp 10500 10500
Total Variable costs 367500 367500
Contribution Margin 562500 562500
Less: Fixed Expenses:
Fixed OH Costs 24000 24000
Fixed Selling Exp 3900 3900
Total Fixed Costs 27900 27900
Net Income 534600 534600

Related Solutions

Serial Problem Business Solutions (Indirect) LO P1, P2, P3 Santana Rey, owner of Business Solutions, decides...
Serial Problem Business Solutions (Indirect) LO P1, P2, P3 Santana Rey, owner of Business Solutions, decides to prepare a statement of cash flows for her business using the following financial data.    BUSINESS SOLUTIONS Income Statement For Three Months Ended March 31, 2018 Computer services revenue $ 24,307 Net sales 18,293 Total revenue 42,600 Cost of goods sold $ 14,852 Depreciation expense—Office equipment 390 Depreciation expense—Computer equipment 1,200 Wages expense 2,750 Insurance expense 535 Rent expense 2,475 Computer supplies expense...
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...
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 42 desk units (sales price of $1,270) and 22 chairs (sales price of $520). BUSINESS SOLUTIONS—Computer Furniture Segment Segment Income Statement* For Quarter Ended March 31, 2020 Sales† $ 194,340 Cost of goods sold‡ 145,440 Gross profit 48,900 Expenses Sales commissions (10%) 19,434 Advertising expenses 9,600 Other fixed...
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 41 desk units (sales price of $1,260) and 21 chairs (sales price of $510). BUSINESS SOLUTIONS—Computer Furniture Segment Segment Income Statement* For Quarter Ended March 31, 2020 Sales† $ 187,110 Cost of goods sold‡ 140,160 Gross profit 46,950 Expenses Sales commissions (10%) 18,711 Advertising expenses 9,300 Other fixed...
Santana Rey expects sales of Business Solutions’s line of computer workstation furniture to equal 300 workstations...
Santana Rey expects sales of Business Solutions’s line of computer workstation furniture to equal 300 workstations (at a sales price of $4,000 each) for 2019. The workstations’ manufacturing costs include the following. Direct materials $ 710 per unit Direct labor $ 310 per unit Variable overhead $ 80 per unit Fixed overhead $ 24,000 per year The selling expenses related to these workstations follow. Variable selling expenses $ 45 per unit Fixed selling expenses $ 3,200 per year Santana is...
Serial Problem Business Solutions LO P2, A3 Part A Santana Rey of Business Solutions is evaluating...
Serial Problem Business Solutions LO P2, A3 Part A Santana Rey of Business Solutions is evaluating her inventory to determine whether it must be adjusted based on lower of cost or market rules. Business Solutions has three different types of software in its inventory, and the following information is available for each. Per Unit Inventory Items Units Cost Market Office productivity 6 $ 86 $ 84 Desktop publishing 5 114 110 Accounting 6 100 106 Required: 1. & 2. Compute...
Serial Problem Business Solutions LO P3 Santana Rey receives the March bank statement for Business Solutions...
Serial Problem Business Solutions LO P3 Santana Rey receives the March bank statement for Business Solutions on April 11, 2020. The March 31 bank statement shows an ending cash balance of $68,266. The general ledger Cash account, No. 101, shows an ending cash balance per books of $68,825 as of March 31 (prior to any reconciliation). A comparison of the bank statement with the general ledger Cash account, No. 101, reveals the following. The bank erroneously cleared a $580 check...
Serial Problem Business Solutions LO P1, P2 Santana Rey, owner of Business Solutions, realizes that she...
Serial Problem Business Solutions LO P1, P2 Santana Rey, owner of Business Solutions, realizes that she needs to begin accounting for bad debts expense. Assume that Business Solutions has total revenues of $46,000 during the first three months of 2020, and that the Accounts Receivable balance on March 31, 2020, is $22,617. Required: 1a. Prepare the adjusting entry to record bad debts expense, which are estimated to be 1% of total revenues on March 31, 2020. There is a zero...
Santana Rey expects second-quarter 2018 sales of her new line of computer furniture to be the...
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 42 desk units (sales price of $1,270) and 22 chairs (sales price of $520). Sales $194,340 COGS 145,440 Gross profit 48,900 Expenses Sales commissions (10%) 19,434 Advertising expenses 9,600 Other fixed expenses 18,600 Total expenses 47,634 Net income 1,266 * Reflects revenue and expense activity only related to...
Given: Santana Rey expects second-quarter 2018 sales of her new line of computer furniture to be...
Given: 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 45 desk units (sales price of $1,330) and 28 chairs (sales price of $580) Sales† $ 228,270 Cost of goods sold‡ 150,570 Gross profit 77,700 Expenses Sales commissions (10%) 22,827 Advertising expenses 11,400 Other fixed expenses 20,400 Total expenses 54,627 Net income $ 23,073 * Reflects revenue...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT