Question: ACME Tech inc. Sales (SMillion) Product Line Q1 Q1% of YTD Q2 Q2% of YTD Q3 Q3% of YTD YTD Al 450 550 700
ACME Tech inc. Sales (SMillion) Product Line Q1 Q1% of YTD Q2 Q2% of YTD Q3 Q3% of YTD YTD Al 450 550 700 formula Robot 200 formula 150 220 Smart-Sensor 300 250 250 formula Company total Quarter-Comparison of Comp Total** Formula Formula Formula YTD: Year to date, the sum from beginning to most recent ** Qrtr-Comp: compare Q2 with Q1, and Q3 with Q2 if nearer qurter is lower than father quarter, disply "Decrease"; if nearer qurter is higer than father quarter, disply "Increase"; if the two are the same, disply "Same". Fornulas (Please excuse me: It looks a bit messy with the arrows ad the words "formulas"; but a student in TR class was confused "where we're supposed to write formulas", which forced me to do all the annotations.)
Step by Step Solution
3.48 Rating (161 Votes )
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
