Please put in two separate excel spread sheets. We are the Athens Team

Complete Periods three and four decisions on income, pricing, and marketing. Analyze the impact of your decisions for these two periods. Each person should Attach the Excel file with the correct naming convention.

Complete Periods five and six decisions of the budget project template including costs, expansion opportunity & Period 6 budget.

Your response should be based on your company?s results and status at the end of period 6.

Respond in writing with 100 to 150 words

Include both quantitative analysis and qualitative considerations

Your company has been approached by a European retailer of sports equipment.

They have offered to buy 50,000 soccer balls a month (period) for 12 months at a price of $6 each (that?s 600,000 balls in total over the next year). The units will be shipped FOB shipping point, therefore, the European retailer will pick up all the shipping cost.

Your company will pay no sales commission or incur other selling or marketing variable costs to fill this order.

Would you accept this offer? Why or why not?

Model your options using Period 6, and proceed with your decision. Use your decision then create a budget for Period 6. Use the attached Period 6 budget file.

Attach both Excel spreadsheets as well as your Analysis ofthe expansion proposal. Be sure to use the appropriate naming conventions for your files.

AC 721 Budget exercise First, decide how many soccer balls you'll sell and make then complete below: Use period 5 as your base, and budget period 6 Step 1: Calculation of next month's average inventory cost Costs: of beginning inventory direct materials in new manufacturing direct labor in new manufacturing fixed overhead in new manufacturing Total costs Units: of beginning inventory of new manufacturing Total units Average cost per unit Step 2 - Estimate an Income statement (per GAAP) Sales Cost of goods sold at average cost Gross margin Sales commissions Marketing expense Administrative expense Interest revenue ( - = expense) Net income Step 3: Estimate a statement of cash flows Collections from customers Paid for direct materials Paid for direct labor Paid for factory overhead Paid for sales commissions Paid for marketing costs Paid for administrative costs Received as interest revenue (- paid expense) Cash produced (-used) Predict the period ending Balance sheet: Assets: Cash Inventory Liabilities- Debt Shareholders' equity-beginning Earnings to date Amount budgeted for next period Remember - your assets total (cash and Inventory) must equal your debt, equity, and earnings to date Kendra Bryant #K#e#n#d#r#a# #B#r#y#a#n#t# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #