Carreras Café is a Spanish restaurant in a college town. The owner expects that the number of meals served in June will be 40 percent below those served in May, because so many students leave for the summer. In May, the restaurant served 4,800 meals at an average price of $20. In the summer (June through August), the average price of a meal typically increases by 25 percent and the average food cost of a meal increases by 10 percent. Other costs are typically unchanged during the summer. The following cost information is available for May. Service costs (variable with respect to meals) Variable service costs (with respect to meals) Food costs $10,800 16,700 6,200 9,200 $42,900 Labor Other variable costs Fixed service costs Total service costs Marketing and administrative costs Marketing (variable with respect to meals) Administrative (fixed) Total marketing and administrative costs 5,900 4,300 $10,200 Total costs $53,100 Required: Prepare a budgeted income statement for June. (Do not round intermediate calculations.)

Carreras Café is a Spanish restaurant in a college town. The owner expects that the number of meals served in June will be 40 percent below those served in May, because so many students leave for the summer. In May, the restaurant served 4,800 meals at an average price of $20. In the summer (June through August), the average price of a meal typically increases by 25 percent and the average food cost of a meal increases by 10 percent. Other costs are typically unchanged during the summer. The following cost information is available for May. Service costs (variable with respect to meals) Variable service costs (with respect to meals) Food costs $10,800 16,700 6,200 9,200 $42,900 Labor Other variable costs Fixed service costs Total service costs Marketing and administrative costs Marketing (variable with respect to meals) Administrative (fixed) Total marketing and administrative costs 5,900 4,300 $10,200 Total costs $53,100 Required: Prepare a budgeted income statement for June. (Do not round intermediate calculations.)

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 26E: Ingles Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other...

See similar textbooks

Similar questions

Garrison Boutique, a small novelty store, just spent $4,000 on a new software program that will help in organizing its inventory. Due to the steep learning curve required to use the new software, Garrison must decide between hiring two part-time college students or one full-time employee. Each college student would work 20 hours per week, and would earn $1 S per hour. The full-time employee would work 40 hours per week and would earn $15 per hour plus the equivalent of $2 per hour in benefits. Employees are given two polo shirts to wear as their uniform. The polo-shirts cost Garrison $10 each. What are the relevant costs, relevant revenues, sunk costs, and opportunity costs for Garrison?
Hogs & Dawgs is an ice cream parlor on the border of north-central Louisiana and southern Arkansas that serves 43 flavors of ice creams, sherbets, frozen yogurts, and sorbets. During the summer Hogs & Dawgs is open from 1:00 p.m. to 10:00 p.m. on Monday through Saturday, and the owner believes that sales change systematically from hour to hour throughout the day. She also believes her sales increase as the outdoor temperature increases. Hourly sales and the outside temperature at the start of each hour for the last week are provided in the file IceCreamSales. Construct a time series plot of hourly sales and a scatter plot of outdoor temperature and hourly sales. What types of relationships exist in the data? Use a simple regression model with outside temperature as the causal variable to develop an equation to account for the relationship between outside temperature and hourly sales in the data. Based on this model, compute an estimate of hourly sales for today from 2:00 p.m. to 3:00 p.m. if the temperature at 2:00 p.m. is 93°F. Use a multiple linear regression model with the causal variable outside temperature and dummy variables as follows to develop an equation to account for both seasonal effects and the relationship between outside temperature and hourly sales in the data in the data: Hour1 = 1 if the sales were recorded between 1:00 p.m. and 2:00 p.m., 0 otherwise; Hour2 = 1 if the sales were recorded between 2:00 p.m. and 3:00 p.m., 0 otherwise; Hour8 = 1 if the sales were recorded between 8:00 p.m. and 9:00 p.m., 0 otherwise. Note that when the values of the 8 dummy variables are equal to 0, the observation corresponds to the 9:00-to-l0:00-p.m. hour. Based on this model, compute an estimate of hourly sales for today from 2:00 p.m. to 3:00 p.m. if the temperature at 2:00 p.m. is 93°F. Is the model you developed in part (b) or the model you developed in part (c) more effective? Justify your answer.
Ingles Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The table tops are manufactured by Ingles, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 16 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40 percent of next months sales are in the finished goods inventory. Ingles also purchases sufficient materials to ensure that materials inventory is 60 percent of the following months scheduled production. Ingless sales budget in units for the next quarter is as follows: Ingless ending inventories in units for July 31 are as follows: Required: 1. Calculate the number of tables to be produced during August. 2. Disregarding your response to Requirement 1, assume the required production units for August and September are 2,100 and 1,900, respectively, and the July 31 materials inventory is 4,000 units. Compute the number of table legs to be purchased in August. 3. Assume that Ingles Corporation will produce 2,340 units in September. How many employees will be required for the Assembly Department in September? (Fractional employees are acceptable since employees can be hired on a part-time basis. Assume a 40-hour week and a 4-week month.) (CMA adapted)
Cloud Shoes manufactures recovery sandals and is planning on producing 12.000 units in March and 11,500 in April. Each sandal requires 1.2 yards if material, which costs $3.00 per yard. The companys policy is to have enough material on hand to equal 15% of next months production needs and to maintain a finished goods inventory equal to 20% of the next months production needs. What is the budgeted cost of purchases for March?
Alard Manufacturing Company has a billing department staffed by four billing clerks. Each clerk is paid 32,000 per year and is able to process 8,000 bills. Last year, 27,360 bills were processed by the four agents. Calculate the unused capacity in terms of number of bills. a. 27,360 b. 4,640 c. 8,000 d. 32,000
The Silver Star Bicycle Company will manufacture both mens and womens models for its Easy-Pedal bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 mens and 125 womens models to be shipped during the first month and 200 mens and 150 womens models to be shipped during the second month. Additional data are as follows: Last month, the company used a total of 1,000 hours of labor. The companys labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have at least 25 units of each model in inventory at the end of the two months. (Hint: Define variables for production and inventory held in each period for each product. Then use a constraint to define the relationship between these: inventory from end of previous period + produced this period demand this period = inventory at end of this period.) a. Establish a production schedule that minimizes production and inventory costs and satisfies the labor-smoothing, demand, and inventory requirements. What inventories will be maintained and what are the monthly labor requirements? b. If the company changed the constraints so that monthly labor increases and decreases could not exceed 50 hours, what would happen to the production schedule? How much will the cost increase? What would you recommend?
Sunrise Poles manufactures hiking poles and is planning on producing 4,000 units in March and 3,700 in April. Each pole requires a half pound of material, which costs $1.20 per pound. The companys policy is to have enough material on hand to equal 10% of the next months production needs and to maintain a finished goods inventory equal to 25% of the next months production needs. What is the budgeted cost of purchases for March?
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Rehydrator makes a nutrition additive and expects to sell 3,000 units in January, 2,000 in February, 2,500 in March, 2,700 in April. and 2,900 in May. The required ending inventory is 20% of the next months sales, and the beginning inventory on January 1 was 600 units. Prepare a production budget for the first four months of the year.
This year, Hassell Company will ship 4,000,000 pounds of chocolates to customers with total order-filling costs of 900,000. There are two types of customers: those who order 50,000 pound lots (small customers) and those who order 250,000 pound lots (large customers). Each customer category is responsible for buying 1,500,000 pounds. The selling price per pound is 2 per lb for the 50,000 pound lot and 3 per lb for the larger lots, due to differences in the type of chocolate. ABC would likely assign order-filling costs to the customer type as follows: a. 450,000, small; 450,000, large (using pounds as the driver) b. 360,000, small; 540,000, large (using revenue as the driver) c. 750,000, small; 150,000, large (using number of orders as the driver) d. 450,000, small; 450,000, large (using customer type as the driver)
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.
Crescent Company produces stuffed toy animals; one of these is Arabeau the Cow. Each Arabeau takes 0.20 yard of fabric (white with irregular black splotches) and eight ounces of polyfiberfill. Fabric costs 3.50 per yard and polyfiberfill is 0.05 per ounce. Crescent has budgeted production of Arabeaus for the next four months as follows: Inventory policy requires that sufficient fabric be in ending monthly inventory to satisfy 20 percent of the following months production needs and sufficient polyfiberfill be in inventory to satisfy 40 percent of the following months production needs. Inventory of fabric and polyfiberfill at the beginning of October equals exactly the amount needed to satisfy the inventory policy. Each Arabeau produced requires (on average) 0.10 direct labor hour. The average cost of direct labor is 15 per hour. Required: 1. Prepare a direct materials purchases budget of fabric for the last quarter of the year showing purchases in units and in dollars for each month and for the quarter in total. 2. Prepare a direct materials purchases budget of polyfiberfill for the last quarter of the year showing purchases in units and in dollars for each month and for the quarter in total. 3. Prepare a direct labor budget for the last quarter of the year showing the hours needed and the direct labor cost for each month and for the quarter in total.