Province Designs reported the following amounts on its balance sheets at December 31, 2018, 2017, and 2016: (Click the icon to view the data.) Sales and profits are high. Nevertheless, Province is experiencing a cash shortage. Perform a vertical analysis of the company's assets at the end of years 2018, 2017, and 2016. Use the analysis to explain the reason for the cash shortage. Perform a vertical analysis of Province Software's assets at the end of years 2018, 2017, and 2016. (Round your answers to the nearest one-tenth of a percent, X.X%.) Province Designs, Inc. Vertical Analysis Years Ended December 31, 2018, 2017, and 2016 2018 2017 2016 Amount Percent Amount Percent Amount Percent Cash $ 28,000 % $ 20,280 % $ 18,640 % Receivables, net Inventory 33,600 % 20,280 % 23,300 % 257,600 % 192,660 % 144,460 % Prepaid expenses 11,200 % 20,280 % 13,980 % 229,600 253,500 265,620 Property, plant and equipment, net % % % $ 560,000 $ 507,000 $ 466,000 Total assets % % % Use the analysis to explain the reason for the cash shortage. Province's cash shortage is likely due to the dramatic in Data table 2018 2017 2016 Cash $ 28,000 $ 20,280 $ 18,640 Receivables, net 33,600 20,280 23,300 Inventory 257,600 192,660 144,460 Prepaid expenses 11,200 229,600 20,280 13,980 253,500 265,620 Property, plant and equipment, net $ 560,000 $ 507,000 $ 466,000 Total assets Print Done as a percent of total assets. Property, plant and equipment appears to be and due to the in inventory which has led to a tight cash position