Using the Goal Seek function in Microsoft Excel, prepare an Excel spreadsheet to answer the following questions: Warner Clothing is considering the introduction of a new baseball cap for sales by local vendors. The company has collected the following price and cost characteristics:

Sales Price$15 per unit
Variable cost 3 per unit
Fixed cost 42,000 per month

Required
a. What number must Warner sell per month to break even?
b. What number must Warner sell per month to make an operating profit of $30,000?

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

Magic realm, inc., has developed a new fantasy board game. the company sold 15,000 games last year at a selling price of $20 per game. fixed expenses associated with the game total $182,000 per year, and variable expenses are $6 per game. production of the game is entrusted to a printing contractor. variable expenses consist mostly of payments to this contractor.required: 1-a. prepare a contribution format income statement for the game last year.1-b. compute the degree of operating leverage.2. management is confident that the company can sell 58,880 games next year (an increase of 12,880 games, or 28%, over last year). given this assumption: a. what is the expected percentage increase in net operating income for next year? b. what is the expected amount of net operating income for next year? (do not prepare an income statement; use the degree of operating leverage to compute your answer.)

Which of the following statements regarding the southern economy at the end of the nineteenth century is accurate? the south was producing as much cotton as it had before the civil war.