Beginning Inventory Ending Inventory Purchases Revenues Food $110,000 $98,470 $488,000 $1,268,000 b. The following additional information about April's food and beverage costs is also available. Use this data to calculate net costs of sales for food and beverage. (Express your answer in dollars and percentages.) Transfers to Bar Transfers from Bar Employee Meals Complimentary Meals Complimentary Beverages Beverage $38,500 $41,000 $161,000 $742,000 $5,170 $6,850 $7,640 $2,290 $840 c. By what amounts are the food and beverage costs over- or understated, based on com- parisons between the unadjusted and net costs?

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter12: Capital Investment Analysis
Section: Chapter Questions
Problem 1TIF: Ethics in Action Danielle Hastings was recently hired as a cost analyst by CareNet Medical Supplies...
icon
Related questions
Topic Video
Question
Do problem 2 a through c
### Inventory Analysis and Cost Calculations

#### Part b: Food and Beverage Costs

##### Inventory and Revenue Data

- **Food**
  - Beginning Inventory: $110,000
  - Ending Inventory: $98,470
  - Purchases: $488,000
  - Revenues: $1,268,000

- **Beverage**
  - Beginning Inventory: $38,500
  - Ending Inventory: $41,000
  - Purchases: $161,000
  - Revenues: $742,000

##### Additional Cost Information

The following adjustments are needed to calculate the net costs of sales for food and beverages:

- **Transfers to Bar:** $5,170
- **Transfers from Bar:** $6,850
- **Employee Meals:** $7,640
- **Complimentary Meals:** $2,290
- **Complimentary Beverages:** $840

**Question:**
Calculate how food and beverage costs are over- or understated by comparing unadjusted to net costs, and express the answers in dollars and percentages.

---

#### Problem 3: Ground Beef Inventory Valuation

The Pleasant Meadows Restaurant uses frozen ground beef in 10-pound poly bags, costing $30 per bag as received in January. Use the following information to calculate the end-of-January inventory value:

- **January 1 Inventory:**
  - Count: 17 bags
  - Ending Inventory Value: $28.00 per bag

- **January 31 Inventory:**
  - Count: 28 bags
  - Ending Inventory Value: $30.00 per bag

- **Purchases:**
  - 37 bags were purchased during January.

**Tasks:**

a. **FIFO Method:** Calculate the value of ground beef inventory.
   
b. **LIFO Method:** Calculate the value using the last-in, first-out approach.

c. **Actual Cost Method:** Calculate the value using present rotation systems.

d. **Weighted Average Method:** Determine the inventory value applying a weighted average. 

---
This exercise engages students in using inventory methods such as FIFO, LIFO, and weighted averages, to handle real-world restaurant inventory challenges.
Transcribed Image Text:### Inventory Analysis and Cost Calculations #### Part b: Food and Beverage Costs ##### Inventory and Revenue Data - **Food** - Beginning Inventory: $110,000 - Ending Inventory: $98,470 - Purchases: $488,000 - Revenues: $1,268,000 - **Beverage** - Beginning Inventory: $38,500 - Ending Inventory: $41,000 - Purchases: $161,000 - Revenues: $742,000 ##### Additional Cost Information The following adjustments are needed to calculate the net costs of sales for food and beverages: - **Transfers to Bar:** $5,170 - **Transfers from Bar:** $6,850 - **Employee Meals:** $7,640 - **Complimentary Meals:** $2,290 - **Complimentary Beverages:** $840 **Question:** Calculate how food and beverage costs are over- or understated by comparing unadjusted to net costs, and express the answers in dollars and percentages. --- #### Problem 3: Ground Beef Inventory Valuation The Pleasant Meadows Restaurant uses frozen ground beef in 10-pound poly bags, costing $30 per bag as received in January. Use the following information to calculate the end-of-January inventory value: - **January 1 Inventory:** - Count: 17 bags - Ending Inventory Value: $28.00 per bag - **January 31 Inventory:** - Count: 28 bags - Ending Inventory Value: $30.00 per bag - **Purchases:** - 37 bags were purchased during January. **Tasks:** a. **FIFO Method:** Calculate the value of ground beef inventory. b. **LIFO Method:** Calculate the value using the last-in, first-out approach. c. **Actual Cost Method:** Calculate the value using present rotation systems. d. **Weighted Average Method:** Determine the inventory value applying a weighted average. --- This exercise engages students in using inventory methods such as FIFO, LIFO, and weighted averages, to handle real-world restaurant inventory challenges.
## Educational Transcript

### Technology and Food and Beverage Costs

- **Automated food cost control systems**
- **Automated beverage cost control systems**
- **Automated restaurant beverage dispensing systems**

### Problems

#### Problem 1
Use the following data to answer the question below about actual food and beverage costs for the Marina Bay Grill for July:

- **Ending Inventory (Food):** $68,000
- **Ending Inventory (Beverage):** $23,470
- **Food Purchases:** $305,000
- **Beverage Purchases:** $24,700
- **Beginning Inventory (Food):** $72,400
- **Beginning Inventory (Beverage):** $19,700
- **Transfers to Bar:** $3,870
- **Beverage Theft/Pilferage:** $510
- **Food Over-Portioning Expense:** $615
- **Transfers from Bar:** $4,100
- **Complimentary Food:** $2,160
- **Complimentary Beverages:** $890
- **Employee Meal Cost:** $11,225
- **Food Revenues:** $878,000
- **Beverage Revenues:** $116,500

**Question:** What is the net cost of sales for food and beverage? Indicate dollar and percentage costs.

#### Problem 2

a. What are the unadjusted food and beverage costs for the Hillside Resort, given the following information for April? (Express your answer in dollars and percentages.)  

(Note: The data for Problem 2 is not provided in the image.)
Transcribed Image Text:## Educational Transcript ### Technology and Food and Beverage Costs - **Automated food cost control systems** - **Automated beverage cost control systems** - **Automated restaurant beverage dispensing systems** ### Problems #### Problem 1 Use the following data to answer the question below about actual food and beverage costs for the Marina Bay Grill for July: - **Ending Inventory (Food):** $68,000 - **Ending Inventory (Beverage):** $23,470 - **Food Purchases:** $305,000 - **Beverage Purchases:** $24,700 - **Beginning Inventory (Food):** $72,400 - **Beginning Inventory (Beverage):** $19,700 - **Transfers to Bar:** $3,870 - **Beverage Theft/Pilferage:** $510 - **Food Over-Portioning Expense:** $615 - **Transfers from Bar:** $4,100 - **Complimentary Food:** $2,160 - **Complimentary Beverages:** $890 - **Employee Meal Cost:** $11,225 - **Food Revenues:** $878,000 - **Beverage Revenues:** $116,500 **Question:** What is the net cost of sales for food and beverage? Indicate dollar and percentage costs. #### Problem 2 a. What are the unadjusted food and beverage costs for the Hillside Resort, given the following information for April? (Express your answer in dollars and percentages.) (Note: The data for Problem 2 is not provided in the image.)
Expert Solution
Step 1

Inventory refers to all the items, goods, merchandise, and materials held by a business for selling in the market to earn a profit.

Inventory is an asset because a company invests money in it that it then converts into revenue when it sells the stock.

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning