*** *** ******** files *** *** answers *** *** ***** calculationsProject 3: ****** to ********************* in ************* ******* industries ***** ** *** **** time comparing *** ********* ****** of their organization ** the ***** *********** **** ** **** ** ******** *** ******** ** *** ********* ********** **** ** *** areas ******** ** managers ******* *** CFO ** the ******* *** accounting work ** *** **** **** ** ******* *** ********** information is ******** to **** *** ******** and external ************ *** ******** ************ need *** ********** *********** ** evaluate *** ***** ******* ** *** **** ** **** as it ********** On *** convers *** ********** *********** ** ***** ** *** internal ********** ******* **** *** ** judge *** ********** *** optimality of operations ***** * ***** *** ***** ********* *** other areas ** ********** and ******* work in *** **** You ******* that ********** *********** is *** only ****** ** ******** stakeholders for ********** *** **** *** **** by ********** ** ***** *** ********** *** ********** ** operations This ***** *** *********** ** a financial ****** ** ******* *** *********** ****** by both *** ******** and ******** ************ *** ******* ***** ******** * financial ****** *** ********* MiniX *** MiniY based ** ******* questionsStep ** ******** CostsThis ******* addresses the ********** option ****** to *** ********* **** **** ********** of ***** *** production ******* ****** the ************* ** * productQuestion 1: ** Method * **** ***** ** *** cost-per-unit of ********* ********* ***** ******* ***** as the ********** ****** **** would ** *** ************* ***** ***** ** *** ********** basis?Calculation *** the **** allocationTotal ******** Cost (TVC)$2000000000Total ***** Cost ******************** ******************** ******* ***** ***** Allocation)Processor01500 ************************************************* units20000000*30000/100000$600000000Processor01500 *********************************************** units5000000*30000/100000$150000000Android01 ***** ************************************ Allocation * ******************** units20000000*120/200$1200000000Android01300 *************************************** (Each Unit)8000000/300$2666667Total **** *** **** *** ******** ***** ****** *********** **** ******** **************** **** *************** ************************ *** ********* *********************************************** **** *** ******** **** ************ AAllocation ** cost ******** Space)Cost *** ****************** *** ***** *** **************************** ******************** per Unit$5500000Based ** *** *********** above by use ** ****** B *** **** ** ********* *** **** ** ********* ***** be $4500000 when utilizing ******* ***** ** the ***** of ********** ** *** converse *** **** of producing *** unit ********* ***** ** *** ***** of allocation would ** ******** ********* *** ******* would ******* **** ** ** allocates *** ***** ***** ****** B ** ********** and ******* space ** *** ********** basisStep 2: *** of ************** *************** ***** ******* ** *** ***** ****** ****** ** ********* ***** **** **** based on *** **** study *** **** activity for ********* ********* and Processor01 is ********* assembly More ** *** total ****** ** assemblies **** **** ** ****** for *** processor01 units ** **** ** *** ************** The **** ** production ** $25 million ** addition every android01 ***** 180 ********** ***** the ********* ********** **** ****** ** *** ********** ** ********* ** *** *** **** ************ 2:The **** ** ********* each **** ** ******* ** *** ** activity-based ******* ***** ** ********** ** *********** ******** **** ******** ** *** ********* ** *** ** ************** ********** ********** (Total ******************** of ********** (each *************** *** each ****************** ** ********** ***** ** ******* 300 ***** *********** ** **** x ****************** ******** **** *** *** ********* ***** * ****************** **** ** producing ********* (each ***** ********* *** ************** costingCost ** ********** the Android01$10800000The ****** ** ***** ** be ************** **** ** ******** per unit$36000The ***** incurred ***** *** **** ************* total **** for each unit ** ********* ******** * *** *** ** activity-based ****************** ** *** ****** *************** that *** *** ******** *** **** ** ******* **** handling *** Android01 and the ***** **** ** *** **** *** units ***** produced *** ******** **** per **** being ****** *** ***** ** *** Android01 at *** markup over full cost *** ** calculated ** *********** UnitNumber ** ********** CostFixed **** ******************* **** ********************** ** ***** *VC *** each UnitTotal *********************** of ************ *** **** ****************** of ********* ********* ******* ** **** for each *********** ***************** **** per UnitTherefore ** *** *** ***** a **** ** *** ***** ** ***** ** ******* markup over **** with *** ***** ** ****** *** each unit It ** ***** ********** that the ****** ** *** ** *** sells ***** **** *** ***** **** *** ***** *** **** ** ******* *** fixed cost ******* constant ** the converse ** **** ***** **** sold ** ***** ** **** preferable ******** to ** *********** ** ***************** ****** ******** ***** of ****** ******** ** ****** maximum ****** ** the *** ********* ** ********** Note **** *** ***** ** ****** ** ** ************ ***** * big **** *** **** the ********** ***** ********* ******** **** employees *** *** ***** ******** ********* ** optimal ***** ** ****** ********** ** significant **** *** *********** ******** ** the table ***** * ****** ************ analysis can be done ** ********* *** best ***** ** ****** *** *** ********** ******** ** ****** for the ******* ************ ** UnitsVariable Cost-per-Unit ******* ************** ($)20060000700002505400066000300480006400035046000590004004500052000The **************************** ************** ************ Variable ************ RevenueMarginal Cost200$60000$70000$14000000$1200000000250$54000$66000$16500000$13500000$50000$30000300$48000$64000$19200000$14400000$18000$18000350$46000$5900020650000$16100000$34000$34000400$45000$4500020800000$18000000$38000$38000To maximize ****** ******** ******* ****** ***** Marginal ****** * ***** * ****** = ****** / ****** * ***** * *********** * ** * QTherefore ** *** **** of *** ******* MR/=MC ** *** ********** **** ** *** ***** IPS ****** consider *** ****** and ********** **** the ******* value ** ************ ****** ** is worth ****** **** *** fixed ***** ** *** *********** ** **** **** ******* ** is *** same *** *** quantities **** Thus ***** ** *** table the ******* ****** ** ******** when *** ***** are **** **** gives *** ********* $64000As **** ** this **** *** ******* ****** ***** ***** ** 300 unitsStep ** *********** on *** ****** of cost ****** of ********** *** *** ***** for *** and the actual ***** for ***** ** ********* ** *** ***** ***** * ****** *** *** *** be prepared ******* *** ***** **** **** **** the number ** ******** **** **** increase ** 3200 **** ** * reflection ** *** ******** ******** in ***** ******* of *** *** ********* *************** Production Cost *********** ********************** ** ***** ************** cost ********** ************* **** ********** ************ ******* ******************* (fixed) 6000000Other ******* ************ ************ ****** *** *** ********* 20X8AprilCost *** **** ************ of MiniY30003200cost ** components ****** price per ***************************** ** ***** (variable) for ******** ***** fixed13500000450014400000Rent (fixed)60000006000000Depreciation ************************** ************************** Amount$5150000054000000Step ** **** ** ****** *** factory ** *** **** ******** **** *** **** ** ********* **** ** produced **** units of * *** **** ***** ** * *** total **** **** combined *** $3000000 Note **** MinX **** *** $2700 *** **** **** ***** MinY goes *** $25000 *** **** unit That information *** ** **** ** assign *** combined ***** ** use of ******** sales ****** ****** to **** and **** **** *** ********** **** *** **** ********** **** **** *** ** ********** ** ***** ***** Note: ***** ** ** ********** that *** fixed *** ******** ***** used ** **** * *** ****** ** this ******** ** ********* the **** and ****** for ****** *** ******************************* ******** 1200000000$ ********** *********** -$ ******** 1400000000$ -$ *********** *********** ************ ******** *********** 450000000$ *********** ******** ******** *********** ******** *********** *********** ************ ******** *********** ********** 1890000000$ ******** ******** *********** 5400000$ *********** 1920000000$ ********* ******** 1610000000$ 450000000$ *********** ******** ******** *********** ******** *********** *********** ******** ******** *********** ********** 2250000000$ ******** ******** *********** ******* 2250000000$ *********** **************** ** ** ******** 5000000$ ******** ******** 3400000$ ******** ******** ********** **** *** output ***** *** profit ************ ** **** *** ******** Revenue **** equates *** marginal Cost **** ** **** assignment *** ****** ***** **** the ******* ***** ** *** ***** **** ** ** the ******* ***** ** ***** ******* ************ a ******* analysis ********* **** *** ****** ***** ** * 50000Recommendation For *** *** to ******* maximum ******* * ***** *** ********* and ********* ** ** ********** *** *** **** to ******* *** units which selling at * 64000 **** ***** **** a ****** ** *********** 7: Managerial ********** Report ** ************* data ********* ********** **** ***** shows **** *** **** *** Android lines is ****** to the ***** ********* *** ********** and ********* *********** ******** *** ******* ** going ******* ************ *** *** ******* ** ******* enjoying increased ****** ** well ******* ****** ** * future there are ****** ** ****** to *** **** ******************** *** ******* needs ** start ********* ******* ***** ** the allocation basis ** *** ********* **** ***** ****** the **** ** ********** **** ***** **** **** *** firm ***** **** more ** well ** make **** profits **** significantly *** ******* ****** produce *** units ** ***** ** *** ***** **** because **** ** the optimal level of ********** Note that ** *** ******* sells 300 ***** ** earns ** percent ****** **** **** **** *** ***** ** $81900 *** **** unitProject ** Report ** ********************* ** ************* ******* ********** ***** ** *** same time ********* the ********* ****** ** their ************ to *** other competitors They do **** ** ******** *** ******** ** the ********* ********** **** of *** ***** explored ** managers ******* *** *** is the ******* and ********** **** ** *** firm This ** ******* the ********** *********** ** ******** ** **** *** ******** *** ******** ************ The external ************ **** the ********** *********** ** ******** *** ***** ******* ** *** **** as well ** it ********** ** the ******* *** ********** information is ***** ** the internal management ******* **** use ** ***** *** ********** *** optimality ** ********** After * ***** you ***** ********* the ***** ***** ** ********** *** finance **** ** *** **** *** ******* **** ********** *********** ** *** **** ****** ** external stakeholders *** ********** *** **** but also ** management ** ***** *** ********** *** ********** ** ********** **** ***** *** preparation ** a ********* ****** ** ******* the *********** needed ** **** *** external *** ******** ************ The ******* paper ******** a ********* ****** *** ********* MiniX *** ***** based ** ******* questionsStep ** ******** ********* section addresses *** production ****** ****** ** *** Android01 **** **** ********** ** costs *** ********** methods ****** *** ************* ** * *************** ** ** ****** * **** ***** ** *** cost-per-unit ** ********* ********* ***** ******* space ** the ********** basis? **** ***** ** *** ************* ***** ***** ** *** ********** ***************** *** *** **** allocationTotal Variable **** ********************* ***** **** (TFC)$500000000Total ******************** ******* ***** ***** ************************* units20000000*70000/100000$1400000000Android01300 ************************************************** *********************************************** units5000000*30000/100000$150000000Android01 ***** ************************************ ********** * ******************** units20000000*120/200$1200000000Android01300 *************************************** ***** Unit)8000000/300$2666667Total **** *** **** for ******** ***** ****** *********** **** ******** **************** **** *************** cost$2000000$2666667Plus *** ********* cost$2500000$2500000Total:$4500000$5166667Total cost for Andoid01 (Per Unit)-Method *********** ** **** (Factory ********** for rent$450000000cost for ***** *** **************************** units$1650000000Cost *** Unit$5500000Based ** *** *********** ***** ** *** ** ****** * *** cost ** ********* *** **** of ********* ***** ** ******** **** ********* ******* ***** ** *** ***** of ********** On *** ******** *** cost of producing one **** utilizing labor as the basis of ********** ***** ** ******** ********* the company would ******* **** if ** allocates its ***** ***** ****** * ** ********** and ******* space as *** ********** ********* 2: *** ** ************** CostingActivity ***** ******* is *** ***** ****** ****** in ********* costs **** **** ***** ** the case ***** *** main ******** *** ********* ********* and Processor01 is component ******** **** ** the total ****** ** ********** **** **** ** ****** *** *** *********** ***** ** well ** 300 android01units *** **** ** production ** $25 ******* ** addition ***** ********* needs *** assemblies ***** *** remaining ********** **** allied ** the ********** of ********* is *** *** **** ************ ***** cost of ********* each **** of Android ** *** ** activity-based ******* would ** ********** ** *********** ******** **** ******** ** the Android01 ** *** of ************** ********** ********** ****** Cost)$25000000Number ** assemblies ***** year)125000Rate for **** ****************** of assemblies ***** ** ******* *** units *********** ** **** * 180)54000Allocated ******** cost *** *** Android01 ***** * ****************** **** of ********* ********* (each ***** utilizing *** activity-based *********** ** assembling *** ********************* ****** ** units to be ************** **** of assembly *** ************* ***** incurred costs *** **** ************* ***** cost *** **** **** ** ********* ******** – *** *** of ************** ****************** ** *** ****** *************** **** *** IPS ******** *** **** ** ******* **** handling *** ********* and *** ***** **** is $45 **** 300 units ***** produced *** ******** cost per unit ***** ****** the ***** ** the Android01 ** *** ****** **** full **** *** ** ********** as follows:Per ********** of ********** ********* **** ******************* **** (VC)4800030014400000no ** Units *VC for each ********* *********************** ** Units300cost *** **** ****************** of UnitsMark ********* percent of cost *** each *********** ***************** **** *** UnitTherefore if the IPS makes * sale of *** ***** ** ***** ** ******* ****** **** **** **** *** price ** $81900 for **** **** It ** ***** ********** **** *** markup is low ** IPS sells units **** *** lower than 300 units are This ** ******* *** ***** **** ******* ******** ** the ******** ** **** ***** **** **** ** ***** ** **** preferable compared ** ** *********** ** ***************** ****** ******** ***** of output ******** ** ensure ******* ****** ** *** *** ********* is ********** **** **** *** ***** ** output ** ** organization ***** * big role for both the ********** ***** executive ******** **** ********* and *** floor managers Therefore ** optimal ***** ** ****** ********** is *********** With *** *********** provided ** the table ***** * ****** ************ analysis *** ** **** ** ********* *** **** ***** ** ****** for *** ********** ******** ** ****** for the ******* levelsNumber ** ************* Cost-per-Unit ******* Price-per-Unit *********************************************************************** CalculationsQuantityVariable ************** RevenueTotal ******** ************ *************** *************************************************************************************************************************************************************************************************************************** ******** profit Marginal ******* should ***** ******** ****** * ***** / ∆QMC * ****** * ∆QTR * ***** * *********** = VC * ********** in *** case of *** because ****** ** *** quantities sold ** all ***** IPS should ******** the ****** *** ********** **** *** ******* ***** ** ************ margin ** is ***** ****** that *** fixed ***** ** *** *********** ** **** case ******* ** ** *** same for *** ********** **** Thus ***** ** our ***** *** ******* ****** ** ******** **** *** ***** are sold **** gives *** ********* ********** ** *********** ** the budget ** cost budget of ********** for the ***** *** May and the actual costs *** ***** ** presented ** *** table ***** * ****** *** *** *** ** ******** stating the ***** **** **** **** *** number ** ******** **** **** ******** ** 3200 **** ** a ********** ** *** expected ******** ** sales because ** *** *** ********* *************** ********** **** *********** 20X8Production–Units ** ***** ************** **** ********** 24000000Labor **** ********** ************ (fixed) ******************* (fixed) ************ ******* ************ $51500000The budget for *** 20x8April ************* for **** ************ ** MiniY30003200cost of components ****** ***** *** ***************************** ** ***** (variable) *** ******** ***** ***************************** ********************************* ************************** (fixed)20000002000000Total Amount$5150000054000000Step ** Loss ** Profit *** ******* ** the case ******** **** *** **** ** September **** it produced **** units ** Y *** **** ***** of X *** total **** **** combined *** ******** Note **** **** **** *** $2700 for **** **** while **** **** *** $25000 *** **** **** **** *********** can be **** ** ****** the ******** ***** by use of ******** ***** ****** ****** ** **** *** MinY **** *** calculated cost *** **** associated **** MinY *** ** ********** ** ***** below ***** ***** ** ** ********** **** *** ***** *** variable ***** **** in step * *** ****** ** **** question to ********* *** **** *** ****** for MinYVC per ******************************* ******** *********** ********** *********** ** 7000000$ 1400000000$ -$ 1650000000$ *********** ************ ******** *********** ********** *********** 3000000$ ******** *********** ******** *********** 1650000000$ (150000000)$ 4800000$ *********** ********** *********** ******** ******** *********** ******** 1890000000$ *********** ********* ******** *********** 450000000$ *********** 3400000$ ******** *********** ******** 2060000000$ 2065000000$ ******** ******** 1800000000$ 450000000$ *********** 3800000$ 5200000$ 2080000000$ ******* 2250000000$ *********** **************** -$ ** ******** ******** 1800000$ ******** 3400000$ ******** ******** 300000Note that *** ****** ***** *** ****** maximization is **** the ******** ******* **** ******* the marginal Cost **** ** **** assignment *** output ***** with *** closest ***** ** *** units **** ** at the ******* price 0f ***** dollars Nevertheless * ******* ******** indicates **** *** profit ***** ** * ******************* For *** *** ** produce ******* ******* * which *** ********* *** effective it ** ********** for the **** ** ******* 300 ***** which ******* ** $ 64000 **** would **** * profit ** *********** ** ********** ********** ****** to ManagementThe **** ********* ********** **** ***** ***** **** the **** and ******* ***** ** headed ** *** ***** ********* *** ********** and ********* information ******** *** ******* ** ***** ******* ************ *** the company ** ******* ******** ********* income as **** ******* ****** in * future ***** are ****** ** ****** ** put **** ******************** the company ***** ** start ********* ******* ***** ** *** ********** ***** ** *** operation **** ***** ****** the **** ** ********** **** ***** **** that *** **** would **** **** ** **** ** **** more profits Most ************* the ******* should produce *** units ** least ** *** short **** ******* that is the ******* ***** ** ********** Note **** ** *** ******* ***** *** ***** ** earns 30 ******* ****** **** **** with the price of $81900 *** **** ****

Click here to download attached files:
The Excell Calculation for question 1.xlsx

Click here to download attached files:
excell sheet for question number two.xlsx

Click here to download attached files:
Excel sheet for Number 3.xlsx

Click here to download attached files:
Excel sheet for question number 4.xlsx

Click here to download attached files:
Excel sheet for question 5.xlsx

Click here to download attached files:
Excell sheet for question 6.xlsx

Click here to download attached files:
Report to management.docx

Click here to download attached files:
revised document.docx