Group Manufacturing Project

DueDec 10 by 11:59pm Points 220 Submitting a file upload

Available untilDec14at11:59pm

ExcelProject:"YourGroupnumber"Manufacturing

HereisaSampleExcelProject,(https://canvas.pasadena.edu/courses/1138105/files/76437483?wrap=1) (https://canvas.pasadena.edu/courses/1138105/files/76437483/download?download_frd=1)(done bystudentswhoneverhadasample)togetanideaaboutwhatyouneedtocreate.Justlikethosestudents whomadethesampleExcelproject,youneedtothink/research/estimateyourcostsfortheproductionof your specific product. It does not need to be exact but it needs to be close, realistic, and meaningful.

Electronicspreadsheetsareafactforallbusinessprofessionals.Itisveryimportantthatyoulearnhow to use Excel to present accounting information. Excel is the most powerful tool used by accountants today. The more you learn Excel the more marketable your skills will be in the job market.

Inordertoreceivefullcredit,youmustbuildthespreadsheetfromscratch.Inotherwords,youmuststart from a blank spreadsheet.

Youmaynotusethepublisher'smodels,mysampleproject,oranyotherspreadsheetthatyoudidnot personally start from blank.

AsagroupofFive,youwillestablishamanufacturingproposalwithallrelatedtablesandbudgetsas your project on a multi-page, formulated, interconnected Excel sheet including the following tabs:

SET1: Cost Basics (50 pts.)

Awell-developed multi-tab interrelated Excel sheet.

Cost Basis

Table1:Materialcostperunit Table 2: Labor cost per unit

Table3:Assets(Equipmentandtheirannualstraight-linedepreciation) Table 4: Overhead

Table5:SellingandAdministrative

VariablecostsFixed costs

Table6:FixandVariableCosts

(CombineTable4and5;remembertoaddDMandDLtothecalculationofthevariablecost)

VariableCosts

DM(FromTable1)

DL(FromTable2)

Variable OH ( FromTable 4) VariableS&A(FromTable5)

Fixed Costs

Fixed OH (From Table 4) FixedS&A(FromTable5)

TotalFixedCosts(ThiswillbeusedforCVPanalysis)

SET2:CostVolumeProfitAnalysis(50 pts.)

EstimatedSellingPrice Contribution Margin

Break-Even Points in Dollars and Units

ProfitPlanning(TargetsalesinDollarsandUnits,tobeusedinsalesbudget)(Note:Targetincome should be almost equal to the net income in the Budgeted Income Statement)

Margin of Safety

SET3:The Master Budget for four quarters (100 pts.)

Sales BudgetProduction Budget EndingInventoryBudget

Selling&AdministrativeExpenseBudget DM Budget

DL Budget MOHBudget Cash Budget

BudgetedIncomeStatement Budgeted Balance Sheet

Memorandum (20 points)

Here is aSample Memo(https://canvas.pasadena.edu/courses/1138105/files/76437476?wrap=1)so you can have an idea about how a memo looks like. You can not copy from my provided samples.

TheExcelprojectof"YourCompanyName"mustbesubmittedwithaBusinessMemorandum.

Amemorandumusually known as a memois a document that is most commonly used for internal

communication between

coworkersormembersofadepartment.Inourcase,theBoardofDirectorsisconcernedaboutthe project's budgeted year profitability.

Eachissueinamemorandumneedsoneparagraph.Youshouldstartwithoneintroductionatthe beginning and finish with one

conclusion at the end of the memorandum. You do not write unnecessary information in the memorandum.Youshouldwriteonlyaboutrequestedissuesanduseaprofitabilityratiotoemphasize your point.

YouneedtowriteamemototheChairoftheBoardofDirectorsabouttheirconcernbasedonyour prepared budgeted Income Statment results and the proposed product profitability.