budgetting

Requirement 2: The company just hired a new marketing manager who insists unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Required information \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & & B & C & 0 & E & F & G \\ \hline 1 & Chapter 8: Applying Excel & & & & & & z & \\ \hline 2 & A & & & & E & & & \\ \hline 3 & Data & & & & & & Year 3 Quarter & 4 \\ \hline 4 & & & 1 & 2 & 3 & 4 & 1 & 2 \\ \hline 5 & Budgeted unit sales & & 50,000 & 70,000 & 105,000 & 70,000 & 80,000 & 100,000 \\ \hline 6 & & & & & & & & \\ \hline 7 & - Selling price per unit & 5 & 7 & per unit & & & +2 & \\ \hline 8. & - Accourts receivatis, beginning talance & 5 & 65,000 & & & & & \\ \hline 9 & - Sales collected in the quarter sales are made & & 76% & & & & & \\ \hline 10 & - Sales collected in the cuarter after sales are made & & 25% & & & & & \\ \hline 11 & - Desired ending finished goods inventory is & & 30% & \multicolumn{5}{|c|}{\begin{tabular}{l} of the budgeted unit soles of the next querter \\ units \end{tabular}} \\ \hline 12 & - Friahed goods unventory, beginning & & 12000 & units & & & & \\ \hline 13 & - Raw mistanats required to produce one unt & & 5 & pounds & & & & \\ \hline 14. & - Desind ending invertory of raw materials is & & 10% & \multicolumn{5}{|c|}{ of the noxt quarter's peoduction needs } \\ \hline 15 & - Paser materiale inventory, beginning & & 23,000 & pounds & & & & \\ \hline 16 & - Raw material costs & 5 & 080 & perpound & & & & \\ \hline 17 & - Raw malerists purchases are paid & & 60% & \multicolumn{5}{|c|}{\begin{tabular}{l} in the quarter the purchases are made \\ in the guares followirg giecte \end{tabular}} \\ \hline 18 & and & & 40 : & \multicolumn{5}{|c|}{ in the quater followirg purchase } \\ \hline 19 & - Acoounte bayabie to tow mulerials, beginning bolench. & 3 & 81,500 & 1. & & & & \\ \hline \end{tabular} Requirement 2: The company just hired a new marketing manager who insists unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Required information \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & & B & C & 0 & E & F & G \\ \hline 1 & Chapter 8: Applying Excel & & & & & & z & \\ \hline 2 & A & & & & E & & & \\ \hline 3 & Data & & & & & & Year 3 Quarter & 4 \\ \hline 4 & & & 1 & 2 & 3 & 4 & 1 & 2 \\ \hline 5 & Budgeted unit sales & & 50,000 & 70,000 & 105,000 & 70,000 & 80,000 & 100,000 \\ \hline 6 & & & & & & & & \\ \hline 7 & - Selling price per unit & 5 & 7 & per unit & & & +2 & \\ \hline 8. & - Accourts receivatis, beginning talance & 5 & 65,000 & & & & & \\ \hline 9 & - Sales collected in the quarter sales are made & & 76% & & & & & \\ \hline 10 & - Sales collected in the cuarter after sales are made & & 25% & & & & & \\ \hline 11 & - Desired ending finished goods inventory is & & 30% & \multicolumn{5}{|c|}{\begin{tabular}{l} of the budgeted unit soles of the next querter \\ units \end{tabular}} \\ \hline 12 & - Friahed goods unventory, beginning & & 12000 & units & & & & \\ \hline 13 & - Raw mistanats required to produce one unt & & 5 & pounds & & & & \\ \hline 14. & - Desind ending invertory of raw materials is & & 10% & \multicolumn{5}{|c|}{ of the noxt quarter's peoduction needs } \\ \hline 15 & - Paser materiale inventory, beginning & & 23,000 & pounds & & & & \\ \hline 16 & - Raw material costs & 5 & 080 & perpound & & & & \\ \hline 17 & - Raw malerists purchases are paid & & 60% & \multicolumn{5}{|c|}{\begin{tabular}{l} in the quarter the purchases are made \\ in the guares followirg giecte \end{tabular}} \\ \hline 18 & and & & 40 : & \multicolumn{5}{|c|}{ in the quater followirg purchase } \\ \hline 19 & - Acoounte bayabie to tow mulerials, beginning bolench. & 3 & 81,500 & 1. & & & & \\ \hline \end{tabular}