Complete Live Case section in the Scenario worksheet. There are 4 scenarios in this model: Consensus, Bull, Bear, and Other. The numbers in the live case should reflect one of the cases based on cell K14, which is dynamically linked to the scenario selected in the dropdown menu at the top of the worksheet. What formula will you use to fill cell G21 (online stores for 2018E)?

Selected t-account balances for bloomfield company are shown below as of january 31, which reflect its accounting adjustments. the firm uses a calendar-year accounting period, but prepares monthly accounting adjustments.suppliesjan. 31 bal. 1,800 1,800 jan. 31 bal.supplies expensejan. 31 bal. 1,920 1,148 jan. 31 bal.prepaid insurancejan. 31 bal. 1,148 1,148 jan. 31 bal.insurance expensejan. 31 bal. 164 164 jan. 31 bal.wages payablejan. 31 bal. 1,400 1,400 jan. 31 bal.wages expensejan. 31 bal. 6,400 6,400 jan. 31 bal.truckjan. 31 bal. 17,376 17,376 jan. 31 bal.accumulated depreciation -truckjan. 31 bal. 5,068 5,068 jan. 31 bal.a. if the amount in supplies expense represents the january 31 adjustment for the supplies used in january, and $1,240 worth of supplies were purchased during january, what was the january 1 beginning balance of supplies? $answerb. the amount in the insurance expense account represents the adjustment made at january 31 for january insurance expense. if the original insurance premium was for one year, what was the amount of the premium, and on what date did the insurance policy start? amount of the premium $answerthe policy began on answerjune 1july 1august 1september 1october 1november 1 of the previous year.c. if we assume that no beginning balance existed in either in either wage payable or wage expense on january 1, how much cash was paid as wages during january? $answerd. if the truck has a useful life of four years (or 48 months), what is the monthly amount of depreciation expense, and how many months has bloomfield owned the truck? answermonths