Answered step by step
Verified Expert Solution
Question
1 Approved Answer
fill in blanks based off assumptions Assumptions: Sales volume increases 500 units each quarter, including Q1 of the next yeat Ending Inventory is 20% of
fill in blanks based off assumptions Assumptions: Sales volume increases 500 units each quarter, including Q1 of the next yeat Ending Inventory is 20% of next quarter's budgeted sales Unit cost is 45% of sales price Salaries are 25% of sales Commissions are 5% of sales Benefits are 25% of salaries Supplies are 1% of sales All other expenses are the same amount each quarter Interest expenses are 1% of Sales Income taxes are 20% of earnings before taxes Rent is $50,000 per quarter Utilities are $5,000 per quarter Depreciation is $20,000 per quarter File Home Insert Pagetayout Formulas Data Review View Automate Help Acrobat (1) PRORECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stry in Protec $49 fx Purchases Budget \begin{tabular}{|c|c|c|c|c|c|} \hline Units Sold & 15,000 & 15,500 & 16,000 & 16,500 & 63,000 \\ \hline Ending Inventory & & & & & - \\ \hline Tablets Needed & 15,000 & 15,500 & 16,000 & 16,500 & \\ \hline Beginning & 3,000 & & 1 & & 3,000 \\ \hline Purchases & 12,000 & 15,500 & 16,000 & 16,500 & 60,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Revenue & & & & & \\ \hline Sales & 1,875,000 & 1,937,500 & 2,000,000 & 2,062,500 & 7,875,000 \\ \hline Cost of Goods Sold & & & & & \\ \hline Gross Profit & 1,875,000 & 1,937,500 & 2,000,000 & 2,062,500 & 7,875,000 \\ \hline \end{tabular} Gross Profit \% Expenses Salaries Commissions Benefits Rent Utilities Supplies Total expenses Operating Income Operating Income \% \begin{tabular}{llll} 1,875,000 & 1,937,500 & 2,000,000 & 2,062,500 \end{tabular} 7,875,000 Depreciation Interest expense Earnings before taxes 1,875,000 1,937,500 2,000,000 2,062,500 7,875,000 Income Taxes Net Income \begin{tabular}{|l|l|l|l|l|} \hline 1,875,000 & 1,937,500 & 2,000,000 & 2,062,500 \\ \hline \end{tabular} 7,875,000 Net income \%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started