Question

M E DIUW Paye Layout Formulas Data Review View Help 12 = Calibri BIU - Font AA = A aste General $ -% 8-98 Conditional Format as Cell Formatting Table Styles Insert EX Delete Format Cells Clipboard Alignment Number Styles - - * fx Master Budget and Responsibility Accounting A B C D L Master Bildget and Responsibility Accounting Direct material budget Dawson Co. produces wine. Dawson purchases empty glass bottles from an outside vendor. The company expects: Production 2,535,000 two-liter bottles of Chablis Target ending inventory 77,000 glass bottles Beginning inventory 54,000 glass bottles For simplicity, ignore breakage. Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Requirement Compute the number of bottles to be purchased in 2018. Saving & Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS INSTRUCTIONS ENTERANSWERS

Answer 1

	# bottles
Target ending inventory	77000
+Requirement for production	2535000
= Total needs	2612000
-Beginning inventory	54000
Required purchases	2558000