Answered step by step
Verified Expert Solution
Question
1 Approved Answer
parts A and B or (#1 and #2 ) please show formulas looking for FORMULAS in your cells. Do not plug numbers into your cells
parts A and B or (#1 and #2 ) please show formulas looking for FORMULAS in your cells. Do not plug numbers into your cells - I want to be able to change the number of sales in units in your Sales Budget and see the WHOLE budget update. Please make sure you interlock your budgets with formulas.
A:l:H1 fx. Master Budget Project MasterBudgetProject Group 09 Vaughan Company makes AM AZING SUPER DUPER Widgets. Management is now preparing detailed budgets for the third quarter, July through S eptember, and has assembled the following information to assist in budget preparation: 1. Sales Budget The marketing department has estimated sales as follows for the remainder of the year: (Actual sales in June were 5,000 units) \begin{tabular}{|r|r|l|r|} \hline July & 4,000 & October & 4,000 \\ \hline August & 12,000 & November & 6,000 \\ \hline September & 15,000 & December & 8,000 \\ \hline \end{tabular} The selling price of a SUPER DUPER widget is $80 and all sales are on account. Based on past experience, sales are collected in the following pattern: 20% in the month of sale 75% in month following the sale 5% are ne ver collected (uncollectible) \begin{tabular}{|c|c|c|c|c|} \hline Vaughan Company & & & & \\ \hline Sales Budget & & & & Total \\ \hline 3rd Quarter & J1ly & August & September & 3rd Quarter \\ \hline Sales in Units & & & & \\ \hline Selling Price per Unit & & & & \\ \hline Tota1 Sales in $ & & & & \\ \hline Cash Collections & & & & \\ \hline June's CashCollections & & & & \\ \hline July's Cash Collections & & & & \\ \hline August's Cash Collections & & & & \\ \hline September's Cash Collections & & & & \\ \hline Tota 1 Cash Collections & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & 0 & c & . & & \\ \hline 36 & & J11y's Cash Collections & & & & \\ \hline 37 & & August's Cash Collections & & & & \\ \hline 3 & & September's Cash Collections & & & & \\ \hline 39 & & Total Cash Collections & & & & \\ \hline \multicolumn{7}{|l|}{40} \\ \hline 41 & 2. & Production Budget & & & & \\ \hline 43 & & \multicolumn{4}{|c|}{ The company maintains a finished goods inventory equal to 10% of the following } & \\ \hline 44 & & \multicolumn{4}{|c|}{ month's sales. The inventory of finished goods on July 1 is as it should be. } & \\ \hline 45 & & VaughanCompany & & & & \\ \hline 47 & & Production Budget & & & & Total \\ \hline 48 & & 3 rd Quarter & July & August & September & 3rd Quarter \\ \hline 49 & & & & & & \\ \hline 50 & & Budgeted Sales in Units & & & & \\ \hline 51 & & Add: Desired Ending Inventory & & & & \\ \hline 52 & & Total Needs & & & & \\ \hline 53 & & Less: Beginning Inventory & & & & \\ \hline 54 & & Required Production & & & & \\ \hline \end{tabular}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