10. Total Expenses and Comparison of Sales: Analyze the following information:
81 82 83 84 85 86
TY
Plan $520,000 $85,000 $90,000
LY $450,000 $86,000 $91,000
Net sales Advertising costs Salaries
$485,000 $82,000 $94,000
Find the following:
a. What are the total expenses in $ and % for TY, Plan, and LY?
Advertising costs Salaries Total expenses Total net sales Expense%
87 88 89 90 91 92 93
TY $82,000 $94,000
Plan $85,000 $90,000
LY $86,000 $91,000
$485,000
$520,000
$450,000
b. What is the comparison (build) of sales for TY versus Plan and TY versus LY?
Net sales Build TY vs. Plan Build TY vs. LY
94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111
TY $485,000
Plan $520,000
LY
$450,000
Skeletal Profit and Loss Statements
Net sales $1,390,000 Gross margin $574,700 Profit $105,000
% 100.0%
Net Sales Problem One - COGS = GM - Expenses = Profit/Loss
$1,390,000
$574,700
$105,000
11. Skeletal Profit and Loss Statement: Set up skeletal profit and loss statement in both dollars and percentage given the information
Gross margin $535,000 Gross margin 25% Expenses $625,000
112 113 114 115 116 117 118 119 120 121 122
Net Sales Problem Two - COGS = GM - Expenses = Profit/Loss
$2,140,000
100.0%
$535,000 $625,000
25.0%
24