Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Curriculum Management Audit

Authors: Larry E. Frase, Fenwick W. English, William K. Poston

1st Edition

0810839318, 9780810839311

More Books

Students also viewed these Accounting questions

Question

7. List behaviors to improve effective leadership in meetings

Answered: 1 week ago

Question

6. Explain the six-step group decision process

Answered: 1 week ago