Please help managerial accounting!!

Need help with Questions E, G and H

This is what I have so far

bealsoudio 18 ACC 3020 Case File Insert Page Layout Formulas Data RviewVie Tell mewhst you wan Cut Copy Wiap Tet General B 1- O-A-l Merge & Center . : $ . % , Format Painter Clipboard Font Nur AH54 7 You are an managerial accou ntant for Blackmore Industries, and you are preparing the 2018 8 budget. Consider the following information, and prepare the r 9 the instructions that follow: 10 11 Sales Information 12 November 2017 unit sales (actual) 13 December 2017 unit sales (actual) 14 January 2018 unit sales (planned) 15 Sales price per unit 16 March 17 For all months in 2018, unit sales are expected to increase 1.2% over the previous month with the 18 exception of March, when a planned unit price increase to $13.75 is expected to decrease March 19 118,729 120,386 123,000 $13.00 13.75 unit sales (compared to February) by 1.9%. The price increase will remain in effect for the rest of 20 the year 21 22 Finished Goods Inventory Planning 23 Blackmore plans to keep 25% of the following month's unit sales on hand in finished goods 24 inventory at the end of any given month. Blackmore has that percentage of January's planned 25 sales (above) on hand at December 31, 2017. 26 27 Accounts Receivable and Collections 28 All sales are on account. Generally, 47% of each month's sales are collected in the month after 29 thesale, while 1.4% are never collected, and eventually written off. All other sales are collected , Problem Solutions Sheeta