Business
Business, 03.01.2020 20:31, unii

The corporation you work for has asked for a summary and report of the future projections for the next 5 years. with the of your cfo, you have put together the following preliminary budget figures based on last year's numbers for a planned production and sales level of 4,000 units per year: building depreciation $200,000/yr. machine operators $100,000/yr. management staff $400,000/yr. direct materials $4,000,000/yr. other expenses that seem to vary based on production levels $3,000,000/yr. other expenses that don't seem to vary $1,300,000/yr. selling price per unit $5,000/unit utilities: this category is difficult to analyze; a part of it is related to the building's heat and light, whereas a part of it is used in the manufacturing process itself. you have the following data to which you will apply the high–low method: when there is no production, utility costs are $20,000/month when production levels reached 4,000 units/month, utility costs totaled $40,000/month you are planning for the future and working on a report based on data from last year's actual performance. you are going to calculate various figures, including the contribution margin per unit, contribution margin ratio, breakeven level in dollars, and breakeven level in units to answer some important questions regarding your data. using only the data from last year's actual performance, create an excel report that answers the questions below, showing all calculations. after completing your excel computations, in microsoft word, write a professional memo to the executive committee analyzing the calculations from your report. within the memo, give your opinion based upon the numbers as to whether production seems to be budgeted properly, and whether the corporation can make an adequate profit above breakeven levels. explain your rationale, and include answers to the following: which of these 8 cost categories would be considered variable, and which fixed? explain why. which costs would be considered mixed (e. g., semi-variable or semi-fixed)? ignoring utility costs altogether, compute the contribution margin per unit, in dollars and in percentage, and the breakeven level of sales. ignoring utility costs altogether, if instead of breaking even, the firm wants to make $10,000/month profit, answer the following: how many units must be sold each month? to how many sales dollars is this unit volume equivalent? in year 2, the ceo plans to add $300,000/yr. expenses in added administrative salaried headcount. ignoring utility costs altogether, how many additional units must be sold just to pay for this added expense?

answer
Answers: 1

Other questions on the subject: Business

image
Business, 21.06.2019 18:50, getsic
Which of the following is not a potential problem with beta and its estimation? sometimes, during a period when the company is undergoing a change such as toward more leverage or riskier assets, the calculated beta will be drastically different than the "true" or "expected future" beta. the beta of "the market," can change over time, sometimes drastically.
Answers: 3
image
Business, 21.06.2019 23:10, angellove1707
You are the new chief information officer for the video-game developer, necturus games. the company has recently undergone a major expansion of its primary product, and you must staff up the is department and determine the best way to develop new game "capsules" for the game, "escape velocity."
Answers: 1
image
Business, 22.06.2019 17:30, chilanka
Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding
Answers: 2
image
Business, 22.06.2019 20:50, agray339
Swathmore clothing corporation grants its customers 30 days' credit. the company uses the allowance method for its uncollectible accounts receivable. during the year, a monthly bad debt accrual is made by multiplying 3% times the amount of credit sales for the month. at the fiscal year-end of december 31, an aging of accounts receivable schedule is prepared and the allowance for uncollectible accounts is adjusted accordingly. at the end of 2012, accounts receivable were dollar 586.000 and the allowance account had a credit balance of dollar 50,000. accounts receivable activity for 2013 was as follows: the company's controller prepared the following aging summary of year-end accounts receivable: prepare a summary journal entry to record the monthly bad debt accrual and the write-offs during the year. (if no entry is required for a particular event, select "no journal entry required" in the first account field.) prepare the necessary year-end adjusting entry for bad debt expense. (if no entry is required for an event, select "no journal entry required" in the first account field.) what is total bad debt expense for 2013? calculate the amount of accounts receivable that would appear in the 2013 balance sheet?
Answers: 2
Do you know the correct answer?
The corporation you work for has asked for a summary and report of the future projections for the ne...

Questions in other subjects:

Konu
Mathematics, 14.09.2020 01:01
Konu
Mathematics, 14.09.2020 01:01
Konu
Mathematics, 14.09.2020 01:01
Konu
Mathematics, 14.09.2020 01:01
Konu
Mathematics, 14.09.2020 01:01
Konu
Mathematics, 14.09.2020 01:01
Konu
Chemistry, 14.09.2020 01:01
Konu
Mathematics, 14.09.2020 01:01
Konu
Mathematics, 14.09.2020 01:01
Konu
Mathematics, 14.09.2020 01:01