Vinall Corporation makes one product and has provided the following information to help prepare the master budget for the next four months of operations: Budgeted selling price per unit $ 86 Budgeted unit sales (all on credit): July 9, 550 August 11, 800 September 10, 450 October 11,400 Raw materials requirement per unit of output 2.1 pounds Raw materials cost $ 2.1 per pound Direct labor requirement per unit of output 2.3 direct labor-hours Direct labor wage rate $ 25.5 per direct labor-hour Credit sales are collected: 30% in the month of the sale 70% in the following month Raw materials purchases are paid: 20% in the month of purchase 80% in the following month The ending finished goods inventory should equal 20% of the following month's sales. The ending raw materials inventory should equal 20% of the following month's raw materials production needs. PLEASE SHOW ALL EQUATIONS IN EXCEL FORMAT! Required: What are the budgeted sales for August? What are the expected cash collections for August? According to the production budget, how many units should be produced in August? If 22, 344 pounds of raw materials are needed for production in September, how many pounds of raw materials should be purchased in August? What is the estimated cost of raw materials purchases for August? If the cost of raw material purchases in July is $45, 449, then in August what are the total estimated cash disbursements for raw materials purchases? What is the total estimated direct labor cost for August assuming the direct labor workforce is adjusted to match the hours required to produce the forecasted number of units produced?
Vinall Corporation makes one product and has provided the following information to help prepare the
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 1 images
