Prepare a flexible budget

I want to check my answers

The Ryder Corporation has done an in depth study of the cost behavior of the overhead costs. They have determined that there are pure fixed costs; there are pure variable costs; and there are mixed costs. Below is a summary for the overhead costs and the cost formulas. The relevant range for the corporation, using direct labor hours as a cost driver, is 4,000 to 6,000 direct labor hours. Ryder Corporation considers 6,000 direct labor hours to be its normal planned activity level. Cost Cost Formula Indirect Labor $1,800 plus $0.25 per DLH Factory Supplies $0.15 per DLH Maintenance $1,500 plus $0.10 per DLH Depreciation $3,000 Utilities $0.11 per DLH Prepare a flexible budget for Ryder Corporation using Excel. Increments (intervals) of 1,000 DLH will be used. (So your columns will be for 4,000, 5,000 and 6,000 DLH). Separate the fixed cost components from the variable cost components. Make sure to do that with mixed costs as well. Using Excel, show your calculation of the Variable Cost Per Unit and the Fixed Cost per Unit. Label each of those two numbers. You will need to watch the demonstration video (handout and link on the HomePage) before you attempt this problem. It must follow the video format in order to be accepted for grading. Don't forget the following: 1. For any mixed cost, the name of the cost and the corresponding values will appear in both the fixed cost AND the variable cost categories on your budget. 2. You must have a column for Cost per Unit, like on the video. Those numbers are your "m" for each variable cost and should be used in the Excel formulas to fill in the budget