I've been stuck for like 4 days. Can someone help me plz?
1. You must setup all eight budgets using Excel. Starting with the sales budget, calculate the sales budget forecast for all four quarters and calculate the total column 2. Each budget should be prepared on individual Excel spreadsheets (on separate tabs) with pages that include links from previous budgets to avoid copying and pasting the same numbers from page to page. Formulas must also be included in the appropriate cells within each spreadsheet. (Demonstrate to the CEO that you have a good working knowledge of EXCEL).. 3. Each budget should professionally represent all the budget information; must be easy to understand so it can be presented to the CEO and the owners of the business. 4. Briefly discuss your assumptions and any challenges you encountered while preparing the budget. (Add this information to the research portion of your paper. (NOT on EXCEL) Note: Endies inventory is eskimated based on zooc of the next quarter's volumex. Note Bedinning inventory is estimated based on 20% of the current quarter's rolumes Note Berinning inventory is 201 based on the current quarter's budget Endinz inventory is tos of the next quarter's budge? Flxed sen Salaries Depre Taxes 8 insurance Totalfaced \begin{tabular}{|r|r|r|r|r|} \hline 5,000.00 & 5,000.00 & 5,000.00 & 5,000.00 & 20,000,00 \\ \hline 900.00 & 900.00 & 900.00 & 900.00 & 3,600,00 \\ \hline 1,700.00 & 1,700.00 & 1,700,00 & 1,700.00 & 6,500.00 \\ \hline 7,600.00 & 7,600.00 & 7,600.00 & 7,600.00 & 30.200 .00 \\ \hline & & & & \\ \hline 9,175,00 & 7,600.00 & 7,600.00 & 7,600.00 & 30,400.00 \end{tabular} coM Cost of Good Manulactured Budget Direct material ased DM inventory 12/31 Purchases Cost of direct materials ovalable for use less direct materials inventory, 12/31 Cost of direct materials used direct laber Manuf OH Total manufacturing cost WIP 12/20 Less WiP 12/20 Cost of goods manutactured Budgeted Income Statement. Sales cos Finished goods inventory 12/31 Cost of good manufactured Less Finished goods (beginning) cos Gross Margin 5EA income from operations Income taxes (3w) Net income Note: Ending inventory is estimated based on 20% of the next quarters volumes. Note Beginring imventory is estmated based on 10% of the current quarter's volumes Direct Materials \$Purhases Note: Beginning inventory is 20% based on the current quarter's budget Ending imventory is 10% of the next quarter's budget Direct Labor Units per unit $ Total Overhead Producton unts Fled \begin{tabular}{lr|r|c|c|c} \hline S\&Admin budge sales & & 3150 & - & - & - \\ \hline Delivery & 0.10 & 315.00 & - & - & - \\ \hline Sales & 0.15 & 47250 & - & - & - \\ \hline Accounting & 0.05 & 157.50 & - & - & - \\ \hline Other & 0.20 & 630.00 & - & - & - \\ \hline Total Variable S\&A & & 1,575.00 & - & - & - \\ \hline \end{tabular} FrodSsA coM Cost of Good Manulactured Budgot Direct material used DM inventory 1231 Purchases Cost of direct materials avallable for use less a direct materials inventory, 12/31 Cost of direct materials used direct labor Manut OH Total manufacturing cost WP 1220 less WP 1220 Cost of goods manutactured Budgeted Income Statement Finished goods inventory 1231 Cost of good manulactured Less Finished goods (beginning) CCB Gross Margn S\&A Income from operations Income taxes (30\%) Net income Write a 2 - 3 page response to the following questions: 1. Describe the code of conduct for accountants and auditors. 2. Research an accounting scandal (within the past 5 year) and describe the ethical issue, identify potential stakeholders affected. 3. Recommend altemative courses of action for the accountant based on the code of ethics you described. 4. Discuss the impact of an unethical behavior on an organization. 5. Discuss how organizations can promote an ethical climate. Note: The paper must be in 12 point Times New Roman with at least one external reference ( 1 reference must NOT include the textbook). Part II - The Budget Project Your first job assignment requires you to create a master budget. The details are presented below. Background Apple Inc. manufacturers 1-phones. You have been hired as a cost accountant and your assignment to create a master budget using EXCEL.. You have been working with various departments to gather financial data to assemble a master budget. One reason you have chosen this format is that upper management will probably make some lastminute changes to sales and possible changes to some other cost forecasts. So, to simplify this problem you MUST create separate sheets for each budget and all budgets should link together so changes can be easily made. For example, if you change the sales forecast, then all the remaining numbers in all other budgets would change without having to change numbers manually in each budget. Some of the information has been input for you but you need to calculate the remaining data points to produce an income statement. 1. You must setup all eight budgets using Excel. Starting with the sales budget, calculate the sales budget forecast for all four quarters and calculate the total column 2. Each budget should be prepared on individual Excel spreadsheets (on separate tabs) with pages that include links from previous budgets to avoid copying and pasting the same numbers from page to page. Formulas must also be included in the appropriate cells within each spreadsheet. (Demonstrate to the CEO that you have a good working knowledge of EXCEL).. 3. Each budget should professionally represent all the budget information; must be easy to understand so it can be presented to the CEO and the owners of the business. 4. Briefly discuss your assumptions and any challenges you encountered while preparing the budget. (Add this information to the research portion of your paper. (NOT on EXCEL) Note: Ending ifventory is estmated based on 20% of the neat quarters volumes. Note Begining inventory is estimated based on 10% of the cumrent quater's volumes Direct Materials SPuthases Note: Beginning imentory is 20% based on the current quatters budget Ending inventory is 10\% of the next quarter's budgot Direct Labor Units per unit Total DL Overhead Production unite Pixed \begin{tabular}{lr|r|c|c|c} \hline S\&Admin budge sales & & 3150 & - & - & - \\ \hline Delivery & 0.10 & 315.00 & - & - & - \\ \hline Sales & 0.15 & 47250 & - & - & - \\ \hline Accounting & 0.05 & 157.50 & - & - & - \\ \hline Other & 0.20 & 630.00 & - & - & - \\ \hline Total Variable S\&A & & 1,575.00 & - & - & - \\ \hline \end{tabular} FrodSsA coM Cost of Good Manulactured Budgot Direct material used DM inventory 1231 Purchases Cost of direct materials avallable for use less a direct materials inventory, 12/31 Cost of direct materials used direct labor Manut OH Total manufacturing cost WP 1220 less WP 1220 Cost of goods manutactured Budgeted Income Statement Finished goods inventory 1231 Cost of good manulactured Less Finished goods (beginning) CCB Gross Margn S\&A Income from operations Income taxes (30\%) Net income 1. You must setup all eight budgets using Excel. Starting with the sales budget, calculate the sales budget forecast for all four quarters and calculate the total column 2. Each budget should be prepared on individual Excel spreadsheets (on separate tabs) with pages that include links from previous budgets to avoid copying and pasting the same numbers from page to page. Formulas must also be included in the appropriate cells within each spreadsheet. (Demonstrate to the CEO that you have a good working knowledge of EXCEL).. 3. Each budget should professionally represent all the budget information; must be easy to understand so it can be presented to the CEO and the owners of the business. 4. Briefly discuss your assumptions and any challenges you encountered while preparing the budget. (Add this information to the research portion of your paper. (NOT on EXCEL) Note: Endies inventory is eskimated based on zooc of the next quarter's volumex. Note Bedinning inventory is estimated based on 20% of the current quarter's rolumes Note Berinning inventory is 201 based on the current quarter's budget Endinz inventory is tos of the next quarter's budge? Flxed sen Salaries Depre Taxes 8 insurance Totalfaced \begin{tabular}{|r|r|r|r|r|} \hline 5,000.00 & 5,000.00 & 5,000.00 & 5,000.00 & 20,000,00 \\ \hline 900.00 & 900.00 & 900.00 & 900.00 & 3,600,00 \\ \hline 1,700.00 & 1,700.00 & 1,700,00 & 1,700.00 & 6,500.00 \\ \hline 7,600.00 & 7,600.00 & 7,600.00 & 7,600.00 & 30.200 .00 \\ \hline & & & & \\ \hline 9,175,00 & 7,600.00 & 7,600.00 & 7,600.00 & 30,400.00 \end{tabular} coM Cost of Good Manulactured Budget Direct material ased DM inventory 12/31 Purchases Cost of direct materials ovalable for use less direct materials inventory, 12/31 Cost of direct materials used direct laber Manuf OH Total manufacturing cost WIP 12/20 Less WiP 12/20 Cost of goods manutactured Budgeted Income Statement. Sales cos Finished goods inventory 12/31 Cost of good manufactured Less Finished goods (beginning) cos Gross Margin 5EA income from operations Income taxes (3w) Net income Note: Ending inventory is estimated based on 20% of the next quarters volumes. Note Beginring imventory is estmated based on 10% of the current quarter's volumes Direct Materials \$Purhases Note: Beginning inventory is 20% based on the current quarter's budget Ending imventory is 10% of the next quarter's budget Direct Labor Units per unit $ Total Overhead Producton unts Fled \begin{tabular}{lr|r|c|c|c} \hline S\&Admin budge sales & & 3150 & - & - & - \\ \hline Delivery & 0.10 & 315.00 & - & - & - \\ \hline Sales & 0.15 & 47250 & - & - & - \\ \hline Accounting & 0.05 & 157.50 & - & - & - \\ \hline Other & 0.20 & 630.00 & - & - & - \\ \hline Total Variable S\&A & & 1,575.00 & - & - & - \\ \hline \end{tabular} FrodSsA coM Cost of Good Manulactured Budgot Direct material used DM inventory 1231 Purchases Cost of direct materials avallable for use less a direct materials inventory, 12/31 Cost of direct materials used direct labor Manut OH Total manufacturing cost WP 1220 less WP 1220 Cost of goods manutactured Budgeted Income Statement Finished goods inventory 1231 Cost of good manulactured Less Finished goods (beginning) CCB Gross Margn S\&A Income from operations Income taxes (30\%) Net income Write a 2 - 3 page response to the following questions: 1. Describe the code of conduct for accountants and auditors. 2. Research an accounting scandal (within the past 5 year) and describe the ethical issue, identify potential stakeholders affected. 3. Recommend altemative courses of action for the accountant based on the code of ethics you described. 4. Discuss the impact of an unethical behavior on an organization. 5. Discuss how organizations can promote an ethical climate. Note: The paper must be in 12 point Times New Roman with at least one external reference ( 1 reference must NOT include the textbook). Part II - The Budget Project Your first job assignment requires you to create a master budget. The details are presented below. Background Apple Inc. manufacturers 1-phones. You have been hired as a cost accountant and your assignment to create a master budget using EXCEL.. You have been working with various departments to gather financial data to assemble a master budget. One reason you have chosen this format is that upper management will probably make some lastminute changes to sales and possible changes to some other cost forecasts. So, to simplify this problem you MUST create separate sheets for each budget and all budgets should link together so changes can be easily made. For example, if you change the sales forecast, then all the remaining numbers in all other budgets would change without having to change numbers manually in each budget. Some of the information has been input for you but you need to calculate the remaining data points to produce an income statement. 1. You must setup all eight budgets using Excel. Starting with the sales budget, calculate the sales budget forecast for all four quarters and calculate the total column 2. Each budget should be prepared on individual Excel spreadsheets (on separate tabs) with pages that include links from previous budgets to avoid copying and pasting the same numbers from page to page. Formulas must also be included in the appropriate cells within each spreadsheet. (Demonstrate to the CEO that you have a good working knowledge of EXCEL).. 3. Each budget should professionally represent all the budget information; must be easy to understand so it can be presented to the CEO and the owners of the business. 4. Briefly discuss your assumptions and any challenges you encountered while preparing the budget. (Add this information to the research portion of your paper. (NOT on EXCEL) Note: Ending ifventory is estmated based on 20% of the neat quarters volumes. Note Begining inventory is estimated based on 10% of the cumrent quater's volumes Direct Materials SPuthases Note: Beginning imentory is 20% based on the current quatters budget Ending inventory is 10\% of the next quarter's budgot Direct Labor Units per unit Total DL Overhead Production unite Pixed \begin{tabular}{lr|r|c|c|c} \hline S\&Admin budge sales & & 3150 & - & - & - \\ \hline Delivery & 0.10 & 315.00 & - & - & - \\ \hline Sales & 0.15 & 47250 & - & - & - \\ \hline Accounting & 0.05 & 157.50 & - & - & - \\ \hline Other & 0.20 & 630.00 & - & - & - \\ \hline Total Variable S\&A & & 1,575.00 & - & - & - \\ \hline \end{tabular} FrodSsA coM Cost of Good Manulactured Budgot Direct material used DM inventory 1231 Purchases Cost of direct materials avallable for use less a direct materials inventory, 12/31 Cost of direct materials used direct labor Manut OH Total manufacturing cost WP 1220 less WP 1220 Cost of goods manutactured Budgeted Income Statement Finished goods inventory 1231 Cost of good manulactured Less Finished goods (beginning) CCB Gross Margn S\&A Income from operations Income taxes (30\%) Net income
