Side 4557 Step 19 of 40: Required Purchases in Dollars 1ste 1 Wally's Widgets 2 Budgeted Sales in Units 3 Add: Ending Inventory 4 Total Needs 5 Less Beginning inventory 6 Required Purchases in Units Required Purchases in Dollars 8 Bugeted Sales in Dollars Sales Commissions in Dollars 10 YOUR TURN: Use the Gross Margin and Sales Price inputs to determine the cost per unit, and then compute the required purchases in dollars. This is calculated as: Sales Price multiplied by (1-Gross Margin Percentage) multiplied by Required Units 10150 10900 12400 12650 10400 10650 12750 OUTI Sear M 1 Wally AUCUS September October November December 2 Budete sa Tip: Excel carries over the Currency format from the 12 Add: Ending Price cell. In some cases cells will return of the had Total Needs column lan't wide enough to display the entire number, 204 5 Less Benning 7 Required Purchases in Units 11900 12150 124001 12 Required Purchases in Dollars 571.400.00 $ 22.900.00 76.500 Budete Sales in Dolars Sales Common in Dollars 10 Cash Flow Budget-David Developer Tell me what you want to do General 5 % Conde Select cells B7:M7 and then choose General from the format list within the Number section of the Home menu Card Students Excel We're ham in hac G N Wall Wirts Puddin February March Anl 10000 10250 10500 6150 6300 6450 16150 56550 16950 6000 6150 6300 10150 10400 10650 May 10750 DO 17350 5450 10900 11000 6250 17750 July 11250 6900 18150 6750 11400 August September 11500 11750 32000 7050 7200 9350 15550 18950 19350 6900 7050 7200 11650 11900 32150 Detober November 12250 12500 7500 7550 19750 2015 7350 7500 12400 12650 M December 1220 7650 20400 11150 Purchasin 3 Purchasin Dollars # Bodin Dollars in Dallas 10 11 Collection 12 12750 LE February March April May June July October November December 14 March 15 16 M 19 23 Dec lama Mart ori M June wy Saptarte O Dec 30 Side 4557 Step 19 of 40: Required Purchases in Dollars 1ste 1 Wally's Widgets 2 Budgeted Sales in Units 3 Add: Ending Inventory 4 Total Needs 5 Less Beginning inventory 6 Required Purchases in Units Required Purchases in Dollars 8 Bugeted Sales in Dollars Sales Commissions in Dollars 10 YOUR TURN: Use the Gross Margin and Sales Price inputs to determine the cost per unit, and then compute the required purchases in dollars. This is calculated as: Sales Price multiplied by (1-Gross Margin Percentage) multiplied by Required Units 10150 10900 12400 12650 10400 10650 12750 OUTI Sear M 1 Wally AUCUS September October November December 2 Budete sa Tip: Excel carries over the Currency format from the 12 Add: Ending Price cell. In some cases cells will return of the had Total Needs column lan't wide enough to display the entire number, 204 5 Less Benning 7 Required Purchases in Units 11900 12150 124001 12 Required Purchases in Dollars 571.400.00 $ 22.900.00 76.500 Budete Sales in Dolars Sales Common in Dollars 10 Cash Flow Budget-David Developer Tell me what you want to do General 5 % Conde Select cells B7:M7 and then choose General from the format list within the Number section of the Home menu Card Students Excel We're ham in hac G N Wall Wirts Puddin February March Anl 10000 10250 10500 6150 6300 6450 16150 56550 16950 6000 6150 6300 10150 10400 10650 May 10750 DO 17350 5450 10900 11000 6250 17750 July 11250 6900 18150 6750 11400 August September 11500 11750 32000 7050 7200 9350 15550 18950 19350 6900 7050 7200 11650 11900 32150 Detober November 12250 12500 7500 7550 19750 2015 7350 7500 12400 12650 M December 1220 7650 20400 11150 Purchasin 3 Purchasin Dollars # Bodin Dollars in Dallas 10 11 Collection 12 12750 LE February March April May June July October November December 14 March 15 16 M 19 23 Dec lama Mart ori M June wy Saptarte O Dec 30
