Activity 1 Tyson's Hardware uses a flexible budget to develop planning information for its warehouse operations. For 20x3, the company anticipated that it would have 96,000 sales units for 664 customer shipments. Average storage bin usage for various inventories was estimated to be 200 per day. The costs and cost drivers were determined to be as follows: Cost driver per 100 units per storage bin per 100 units per shipment per shipment Fixed P10,000 Variable P1.25 Item Product handling Storage Utilities Shipping clerks Supplies 3.00 1.50 1.00 0.50 1,000 1,000 During the year, the warehouse processed 90,000 units for 600 customer shipments. The workers used 225 storage bins on average each day to sort, store, and process goods for shipment. The actual costs for 20x3 were: Item Product handling Storage Utilities Shipping clerks Supplies Actual costs P10,900 465 2,020 1,400 340 Required: a. Prepare a static budget for 20x3 with static-budget variances. b. Prepare a flexible budget for 20x3 with flexible-budget variances.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

What is the answer to the question I uploaded 

Activity 1
Tyson's Hardware uses a flexible budget to develop planning information for its warehouse operations.
For 20x3, the company anticipated that it would have 96,000 sales units for 664 customer shipments.
Average storage bin usage for various inventories was estimated to be 200 per day. The costs and
cost drivers were determined to be as follows:
Item
Product handling
Storage
Utilities
Shipping clerks
Supplies
Cost driver
per 100 units
per storage bin
per 100 units
per shipment
per shipment
Fixed
P10,000
Variable
P1.25
3.00
1.50
1.00
0.50
1,000
1,000
During the year, the warehouse processed 90,000 units for 600 customer shipments. The workers
used 225 storage bins on average each day to sort, store, and process goods for shipment. The actual
costs for 20x3 were:
Item
Product handling
Storage
Utilities
Actual costs
P10,900
465
2,020
1,400
340
Shipping clerks
Supplies
Required:
a. Prepare a static budget for 20x3 with static-budget variances.
b. Prepare a flexible budget for 20x3 with flexible-budget variances.
Transcribed Image Text:Activity 1 Tyson's Hardware uses a flexible budget to develop planning information for its warehouse operations. For 20x3, the company anticipated that it would have 96,000 sales units for 664 customer shipments. Average storage bin usage for various inventories was estimated to be 200 per day. The costs and cost drivers were determined to be as follows: Item Product handling Storage Utilities Shipping clerks Supplies Cost driver per 100 units per storage bin per 100 units per shipment per shipment Fixed P10,000 Variable P1.25 3.00 1.50 1.00 0.50 1,000 1,000 During the year, the warehouse processed 90,000 units for 600 customer shipments. The workers used 225 storage bins on average each day to sort, store, and process goods for shipment. The actual costs for 20x3 were: Item Product handling Storage Utilities Actual costs P10,900 465 2,020 1,400 340 Shipping clerks Supplies Required: a. Prepare a static budget for 20x3 with static-budget variances. b. Prepare a flexible budget for 20x3 with flexible-budget variances.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education