Answered step by step
Verified Expert Solution
Question
1 Approved Answer
using the first 4 photos, please help me figure out the 5th photo. and show work please! Inputs: begin{tabular}{|l|r|} hline 1st quarter unit sales &
using the first 4 photos, please help me figure out the 5th photo. and show work please!
Inputs: \begin{tabular}{|l|r|} \hline 1st quarter unit sales & 20,000 \\ \hline Growth rate in sales per quarter & 20% \\ \hline Selling price & 50 \\ \hline Percent of quarterly sales received in quarter & 25% \\ \hline Unit cost & 35 \\ \hline Desired ending inventory (\% of following qtr CGS) & 85% \\ \hline Percent of purchases paid in month of purchase & 70% \\ \hline Variable expense per unit & 8 \\ \hline Total Fixed expenses & 120,000 \\ \hline Depreciation expense & 25,000 \\ \hline Capital expenditures per quarter & 30,000 \\ \hline Interest rate on loan balance of previous quarter & 1% \\ \hline \end{tabular} Sales Budget \begin{tabular}{|c|c|c|c|c|c|} \hline & & & & & \\ \hline & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 & Year \\ \hline & & & & & \\ \hline Expected unit sales & 20,000 & 24,000 & 28,800 & 34,560 & 107,360 \\ \hline & & & & & \\ \hline Unit selling price & 50 & 50 & 50 & 50 & 50 \\ \hline & & & & & \\ \hline Total sales & 1,000,000 & 1,200,000 & 1,440,000 & 1,728,000 & 5,368,000 \\ \hline \end{tabular} Cash Receipts Budget Purchases Budget \begin{tabular}{|c|c|c|c|c|c|c|} \hline & & & & & & \\ \hline & & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 & Year \\ \hline 4 & & & 0 & & & \\ \hline 5 & Unit cost & 35 & 35 & 35 & 35 & 35 \\ \hline 6 & & & 3 & & & \\ \hline 7 & Budgeted cost of goods sold & 700,000 & 840,000 & 1,008,000 & 1,209,600 & 3,757,600 \\ \hline 8 & & & & & & \\ \hline 9 & Desired ending inventory & 714,000 & 856,800 & 1,028,160 & 3,193,960 & 5,792,920 \\ \hline 10 & & & & & & \\ \hline 11 & 1 Total goods needed & 1,414,000 & 1,696,800 & 2,036,160 & 4,403,560 & 9,550,520 \\ \hline 12 & 2 & & & & & \\ \hline & 3 Expected beginning inventory & 595,000 & 714,000 & 856,800 & 1,028,160 & 3,193,960 \\ \hline & 14 & & & & & \\ \hline & 15 Total purchases & 819,000 & 982,800 & 1,179,360 & 3,375,400 & 6,356,560 \\ \hline \end{tabular} Quarter 1 Purchases Payment Budget
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