American College Glendale Egg Company Budget Excel Workbook 1. I’M GOING TO SEND YOU TWO ATTACHMENTS. ONE OF THE ATTACHMENTS IS THE QUESTIONS, AND THE OTHE

American College Glendale Egg Company Budget Excel Workbook 1. I’M GOING TO SEND YOU TWO ATTACHMENTS. ONE OF THE ATTACHMENTS IS
THE QUESTIONS, AND THE OTHER ONE IS THE INFORMATION YOU ARE GOING TO USE
IN ORDER TO ANSWER THE QUESTIONS.2.YOU ARE ONLY GOING TO ANSWER 5 THROUGH 10… <<<<>>>3. ANSWER TH QUESTIONS BASED OF THE ATTACHMENT I’M GOING TO SEND IT TO YOU4. LET ME KNOW IF YOU HAVE ANY QUESTIONS PLEASE… GOOD LUCK. Using the numbers previously developed in the tables and other chapters, prepare the following budgets using
Excel:
Your group needs to make the budget fluid. (See attached instructions) When making a budget fluid you enter very
little data: after the Sales Budget it is all formulas. Be sure to include your company name and date of the budget
in the heading
Assign each person in the group a budget. Write the name on this page and give it to the instructor.
1.
2.
3.
4.
5.
6.
Sales Budget (In group) and Cash Receipts
Production
Direct Material Budget
Direct Labor Budget
Management Overhead Budget
Cost of Goods Manufactured Budget
Selling and General & Administrative Budget
Income Statement
Cash Budget
Balance Sheet
8.
9.
10.
h
Pay attention to the numbers that come from another budget.
Be sure to divide the work. One person must be in charge (CFO). The CFO should co-ordinate all the budgets and
should prepare the Balance Sheet and Income Statement.

Purchase answer to see full
attachment