Accessibility tab summary: Two data tables for Miami Solar are presented in cells G2 to H4 and G6 to J8. A statement of requirement is presented in rows 10 to 13 and a Direct Materials Budget table for student preparation is presented in cells A15 to B26.
Miami Solar manufactures solar panels for industrial use. The company budgets production of 5,000 units (solar panels) in July and 5,300 units in August.						Units Produced
						July	August
						5,000	5,300
Each unit requires 3 pounds of direct materials, which cost $6 per pound. The companys policy is to maintain direct materials inventory equal to 30% of the next months direct materials requirement. As of June 30, the company has 4,500 pounds of direct materials in inventory.
						Pounds per unit	Cost per pound	Materials requirement	June 30 inventory
						3	$6	30%	4,500