Module 6 - Excel Lab Data Sheet Exercise 15.1 Barnaby's Hideaway uses Jim Beam Bourbon to prepare its Manhattans. A 1-litre bottle of Jim Beam costs $12.50. It also uses Martini & Rossi sweet vermouth at $6.60 per litre in the drink. Compute the cost per ounce for the liquor and the vermouth. Exercise 15.2 Complete the Standard Recipe detail and cost card for a Manhattan using the values from 15.1. The sales price of the drink is $4.50 Exercise 15.3 Barnaby's Hideaway uses Smirnoff vodka to prepare its Vodka Martinis. A 1-litre bottle of Smirnoff costs $15.00. The recipe calls for dry vermouth, which costs $8.00 per litre. Compute the cost per ounce for the liquor and the vermouth.

Module 6 - Excel Lab Data Sheet Exercise 15.1 Barnaby's Hideaway uses Jim Beam Bourbon to prepare its Manhattans. A 1-litre bottle of Jim Beam costs $12.50. It also uses Martini & Rossi sweet vermouth at $6.60 per litre in the drink. Compute the cost per ounce for the liquor and the vermouth. Exercise 15.2 Complete the Standard Recipe detail and cost card for a Manhattan using the values from 15.1. The sales price of the drink is $4.50 Exercise 15.3 Barnaby's Hideaway uses Smirnoff vodka to prepare its Vodka Martinis. A 1-litre bottle of Smirnoff costs $15.00. The recipe calls for dry vermouth, which costs $8.00 per litre. Compute the cost per ounce for the liquor and the vermouth.

Name: Module 6 - Excel Lab Data SheetExercise 15.1Barnaby's Hideaway uses J
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Module 6 - Excel Lab Data SheetExercise 15.1Barnaby's Hideaway uses Jim Beam Bourbon to prepare its Manhattans. A 1-litre bottle of Jim Beam costs $12.50. Italso uses Martini & Rossi sweet vermouth at $6.60 per litre in the drink. Compute the cost p

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Question 1 Use the following standard cost card for 1 gallon of ice cream to answer the questions. STANDARD COST CARD Product: Gallon of Ice Cream Manufacturing Cost Information Standard Standard Cost Cost Quantity per Unit Summary Direct Materials Cream 5 quarts $1.15 per quart $0.08 per ounce $36.00 per hour $5.75 $1.28 Sugar Direct Labor 16 ounces 3 minutes $1.80 Total Direct Costs $8.83 Actual direct costs incurred to make 50 gallons of ice cream: 275 quarts of cream at $1.05 per quart 832 ounces of sugar at $0.075 per ounce 165 minutes of labor at $37 per hour All material used was bought during the current period. А. Compute the material and labor variances. В. possible causes of the variances. Comment on the results and
Question 18 View Policies Current Attempt in Progress E-Flix rents DVDS that are mailed out to customers upon demand. E-Flix has identified three activities involved in getting the videos to its customers. Information on those activities for the month of July follows: Estimated Expected Use of Cost Drivers Cost Pools Cost Drivers Overhead Cost Order taking costs Number of orders $20,592 187,200 orders Technology support Number of minutes $11,700 234,000 minutes Picking and shipping Number of DVDS $39,624 330,200 DVDS costs During July, the Tucker family placed 17 orders consisting of 21 DVDS. Tucker required 7 minutes of tech support. Customers pay $9.00 per month to rent unlimited DVDS. Using ABC, how much overhead is applied to the Tucker family account for technology support? O Some other answer O $1.87 O $0.05 o$0.35 2:28 P ) 10/13/23
Question 2 Use the following standard cost card for 1 gallon of ice cream to answer the questions. STANDARD COST CARD Product: Gallon of Ice Cream Standard Cost Manufacturing Cost Information Standard Cost Quantity per Unit Summary Direct Materials Cream 5 quarts $1.15 per quart $0.08 per ounce $36.00 per hour $5.75 Sugar 16 ounces $1.28 Direct Labor 3 minutes $1.80 Total Direct Costs $8.83 Actual direct costs incurred to make 50 gallons of ice cream: 275 quarts of cream at $1.05 per quart 832 ounces of sugar at $0.075 per ounce 165 minutes of labor at $37 per hour All material used was bought during the current period. C. Compute the material and labor variances. D. Comment on the results and possible causes of the variances.
Problems 1. Use the following standard cost card for 1 gallon of ice cream to answer the questions. Product: Gallon of Ice Cream Manufacturing Costs Direct Materials Cream Sugar Direct Labor Total Direct Costs K Standard Cost Card Standard Quantity 5 quarts 16 ounces 3 minutes x Standard Cost per Unit $1.15 per quart $.08 per ounce $36.00 per hour Actual direct costs incurred to make 50 gallons of ice cream: • 275 quarts of cream at $1.05 per quart • 832 ounces of sugar at $0.075 per ounce • 165 minutes of labor at $37 per hour All material used was bought during the current period. = Cost Summary $5.75 $1.28 $1.80 $8.83 a. Compute the material price, quantity and total variances. b. Compute the labor price quantity, and total variances. What are possible causes of the material and labor variances with respect to the company?
Cleveland Foods Data Note: You can download the Excel file containing Cleveland Foods' data by clicking the above link and perform the necessary calculations for answering the upcoming questions. Question 12 (1 point) □ What is the unit contribution of BlueLiq, considering the given information? $0.70 $2.50 $ 1.00 $1.70 $ $ J 0 20% Retail Margin 2.50 Price to consumers (Retail Price) 15% Wholesale Margin 2.00 Price to retailers (Wholesale Price) $ 1.70 Price to Wholesalers Variable Costs $ 0.70 per unit Fixed Costs Variable Manufacturing Costs $300,000 annual $200,000 Corporate Overhead $250,000 Marketing and Advertising $750,000 Total Fixed Costs Cleveland Foods Data Fixed Manufacturing Costs Note: You can download the Excel file containing Cleveland Foods' data by clicking the above link and perform the necessary calculations for answering the upcoming questions. Question 11 (1 point). Listen 4 What is the price at which Cleveland Foods sells BlueLiq to wholesalers? $1.70 $2.50 $1.00
Chapter 3 Homework Mystic Bottling Company bottles popular beverages in the Bottling Department. The beverages are produced by blending concentrate with water and sugar. The concentrate is purchased from a concentrate producer. The concentrate producer sets higher prices for the more popular concentrate flavors. A simplified Bottling Department cost of production report separating the cost of bottling the four flavors follows: Concentrate Water Sugar Bottles Orange $4,625 1,250 3,000 5,500 3,000 1,750 Total cost transferred to finished goods $19,125 Number of cases 2,500 50,000 Beginning and ending work in process inventories are negligible, so they are omitted from the cost of production report. The flavor changeover cost represents the cost of cleaning the bottling machines between production runs of different flavors. A production run of a new flavor is produced after a flavor changeover from the previous flavor. Higher-demand flavors are produced in larger production runs, while…
Problem 04-4A Evaluating product line costs and prices using ABC LO P3 Bright Day Company produces two beverages, Hi-Voltage and EasySlim. Data about these products follow. Hi-Voltage EasySlim Production volume 12,000 bottles 260,000 bottles Liquid materials 1,600 gallons 33,000 gallons Dry materials 1,120 pounds 12,000 pounds Bottles 12,000 bottles 260,000 bottles Labels 3 labels per bottle 2 label(s) per bottle Machine setups 1,000 setups 800 setups Machine hours 200 MH 3,450 MH Additional data from its two production departments follow. Department Driver Cost Mixing department Liquid materials Gallons $ 1,384 Dry materials Pounds 5,904 Utilities Machine hours 1,460 Bottling department Bottles Units $ 163,200 Labeling Labels per bottle 16,680 Machine setup Setups 27,000 Required:1 & 2. Determine the cost of each product line using ABC. What is the cost per bottle for Hi-Voltage and…
Laboratory Exercise No. 18 Filename: Lab_exer18 A mobile phone store wants you to create a simple application. The program will start by asking the brand of the phone. The user will then enter 10 different prices of that phone for the past months. From the prices entered, be able to count the number of price that is more than 100. Determine also the average price of all the amount. Sample output: Enter price 1 120 Enter price 2 : 50 Enter price 3 75 Enter price 4 : 105 Enter price 5 35 Enter price 6 : Enter price 7 : Enter price 8 : 20 80 115 Enter price 9 : 50 Enter price 10 : 75 Number of prices that is more than 100 : 2 Average of all prices : 72.5
How is process selection related to product design and capacity determination? DQ 2 Read Problem 6: The “Monique Food Processing Company” in Chapter 8 of your text. Monique Food Processing Company produces light snacks that can be heated in a microwave. The following steps are included in the process: Steps Description Capacity (Units/Hour) 1 Prepare food 200 2 Measure and place in plastic pouch 175 3 Prepare cardboard box 200 4 Insert pouch into box 300 5 Shrink-wrap box 200 What is the system capacity, and which is the bottleneck department? How much slack (unused capacity) is available in other departments? How much system capacity can be gained by adding capacity to the bottleneck? What are the key factors that determine when to add…
Assignment 7.1: Session 7 Comprehensive Problem (Chapter 9) Instructions This section has a nine-part comprehensive problem with multiple questions to address. Download the Chapter 9 Comprehensive Problem Template below to complete all parts. You will need your Bergevin and MacQueen book for reference. Redlands Inc. reported standard and actual costs for the product that it manufactures: Item Standard Actual Direct material price $3 per lb. $2 per lb. Direct materials quantity 2 lbs. 4 lbs. Direct labor price $5 $7 Direct labor quantity 3 hours 2 hours Factory overhead cost $2 per machine hour ---- Machine hours per unit 2 machine hours 3 machine hours Number of finished products made 10 12 Number of finished products sold 10 11 Sales per unit $40 $40 * Redlands used machine hours to apply factory overhead costs. The company incurred $90 actual total factory overhead costs to make the 12 products. Based on the information above, complete the following: 1.…
C Access to this pag... 9 studymoose.com ... 8b Erylast Maps Translate Saved Help Sa sp 2022 i Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria's owner has determined that the shop has two major cost drivers-the number of pizzas sold and the number of deliveries made. The pizzeria's cost formulas appear below: Fixed Cost Cost per Cost per per Month Pizza Delivery Pizza ingredients $ 3.80 $ 5,220 $ 630 Kitchen staff Utilities $ 0.05 $ 3.50 $ 1.50 Delivery person Delivery vehicle Equipment depreciation $ 540 $ 275 $ 1,830 $ 820 Rent Miscellaneous $ 0.15 In November, the pizzeria budgeted for 1,200 pizzas at an average selling price of $13.50 per pizza and for 180 deliveries. Data concerning the pizzeria's actual results in November were as follows: Actual Results 1,240 174 Pizzas Deliveries $ 17,420 $ 4,985 $5,281 $984 $609 $ 655 $ 275 $ 1,830 $ 954 Revenue Pizza ingredients…
eBook Question Content Area Rough Stuff makes 2 products: khaki shorts and khaki pants for men. Each product passes through the cutting machine area, which is the chief constraint during production. Khaki shorts take 15 minutes on the cutting machine and have a contribution margin per pair of shorts of $15. Khaki pants take 24 minutes on the cutting machine and have a contribution margin per pair of pants of $30. If it is assumed that Rough Stuff has 4,800 hours available on the cutting machine to service a minimum demand for each product of 3,000 units, how much will profits increase if 104 more hours of machine time can be obtained?