Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

No extra information given, the question sent is completed. Please help to figure out, I'll give upvote. Thank you. VIC Medical assembles three products of

image text in transcribedimage text in transcribedimage text in transcribed

No extra information given, the question sent is completed. Please help to figure out, I'll give upvote. Thank you.

VIC Medical assembles three products of Alpha 5, Alpha 7 and Beta 5, used in medical devices. It is located in Victoria and sells its products through selected distributors in different Australian cities to hospitals and medical centres. Mary has been hired as a recent Swinburne University graduate to assist Philip, the Factory Manager, to analyse sales data and prepare the 2022 budgets. Philip asked Mary to prepare the sales budget for 2022 based on 2020 sales data as all data has been collected and verified. Philip provided Mary with the following sales forecasts for 2022. It is expected that selling prices in 2022 will remain the same as 2020. State Sales forecast for 2022 Alpha 5 Alpha 7 Beta 5 Victoria 5% increase from 2020 5% increase from 2020 5% decrease from 2020 New South Wales 13% increase from 2020 15% increase from 2020 1% decrease from 2020 Queensland 5% increase from 2020 4% increase from 2020 The same as 2020 South Australia 6% decrease from 2020 6% decrease from 2020 2% decrease from 2020 Western Australia The same as 2020 The same as 2020 The same as 2020 Philip also compiled the following data to prepare annual budgets for 2022: Amount used per unit Material Alpha 5 Alpha 7 Beta 5 Electric module 1 unit 1 unit 2 unit LCD 1 unit 1 unit Power supply 1 unit 1 unit 1 unit Sensor 2 units 4 units 5 units Cable A 1 meter 2 meters 4 meters Cable B 1 meter 3 meters 4 meters Wi-Fi module 1 unit Screw A 20 units 23 units 20 units Screw B 10 units 20 units 30 units Washer 10 units 15 units 20 units Raw material prices and inventory levels: Material Anticipated purchase price Expected inventories 1 January Desired inventories 31 December $200 per unit 50 unit 100 unit Electric module LCD $50 per unit 10 unit 100 unit Power supply $50 per unit 10 unit 10 unit Sensor $10 per unit 100 units 150 units Cable A $5 per meter 100 meters 200 meters Cable B $7 per meter 100 meters 150 meters Wi-Fi module $100 per unit 5 units 10 units Screw A $2 per unit 250 units 500 units Screw B $3 per unit 300 units 350 units Washer $1 per unit 100 units 300 units Direct labour requirements and rates: Product Hours per unit Rate per hour Alpha 5 $20 Alpha 7 3 $26 Beta 5 5 $35 Finished goods inventories (in units): Product Expected 1 January Desired 31 December Alpha 5 50 units 100 units Alpha 7 70 units 100 units Beta 5 100 units 200 units Prepare sales budget (in units and dollars) (Round up the number of units): Prepare production budget (in units): Prepare direct material purchases budget (in quantities) Prepare direct material purchases budget (in dollars) Prepare direct labour budget (in hours and dollars): VIC Medical aims to reduce the total raw material cost by 1 per cent in 2022. What should be the purchasing price for "Power supply" if the price of other materials cannot be changed? (report the price in 2 decimal points). To achieve a target direct labour budget of $340,000 in 2022, what should be the labour rate for Beta 5 if the direct labour rare for Alpha 5 and Alpha 7 cannot be changed? (report the rate in 2 decimal points). VIC Medical assembles three products of Alpha 5, Alpha 7 and Beta 5, used in medical devices. It is located in Victoria and sells its products through selected distributors in different Australian cities to hospitals and medical centres. Mary has been hired as a recent Swinburne University graduate to assist Philip, the Factory Manager, to analyse sales data and prepare the 2022 budgets. Philip asked Mary to prepare the sales budget for 2022 based on 2020 sales data as all data has been collected and verified. Philip provided Mary with the following sales forecasts for 2022. It is expected that selling prices in 2022 will remain the same as 2020. State Sales forecast for 2022 Alpha 5 Alpha 7 Beta 5 Victoria 5% increase from 2020 5% increase from 2020 5% decrease from 2020 New South Wales 13% increase from 2020 15% increase from 2020 1% decrease from 2020 Queensland 5% increase from 2020 4% increase from 2020 The same as 2020 South Australia 6% decrease from 2020 6% decrease from 2020 2% decrease from 2020 Western Australia The same as 2020 The same as 2020 The same as 2020 Philip also compiled the following data to prepare annual budgets for 2022: Amount used per unit Material Alpha 5 Alpha 7 Beta 5 Electric module 1 unit 1 unit 2 unit LCD 1 unit 1 unit Power supply 1 unit 1 unit 1 unit Sensor 2 units 4 units 5 units Cable A 1 meter 2 meters 4 meters Cable B 1 meter 3 meters 4 meters Wi-Fi module 1 unit Screw A 20 units 23 units 20 units Screw B 10 units 20 units 30 units Washer 10 units 15 units 20 units Raw material prices and inventory levels: Material Anticipated purchase price Expected inventories 1 January Desired inventories 31 December $200 per unit 50 unit 100 unit Electric module LCD $50 per unit 10 unit 100 unit Power supply $50 per unit 10 unit 10 unit Sensor $10 per unit 100 units 150 units Cable A $5 per meter 100 meters 200 meters Cable B $7 per meter 100 meters 150 meters Wi-Fi module $100 per unit 5 units 10 units Screw A $2 per unit 250 units 500 units Screw B $3 per unit 300 units 350 units Washer $1 per unit 100 units 300 units Direct labour requirements and rates: Product Hours per unit Rate per hour Alpha 5 $20 Alpha 7 3 $26 Beta 5 5 $35 Finished goods inventories (in units): Product Expected 1 January Desired 31 December Alpha 5 50 units 100 units Alpha 7 70 units 100 units Beta 5 100 units 200 units Prepare sales budget (in units and dollars) (Round up the number of units): Prepare production budget (in units): Prepare direct material purchases budget (in quantities) Prepare direct material purchases budget (in dollars) Prepare direct labour budget (in hours and dollars): VIC Medical aims to reduce the total raw material cost by 1 per cent in 2022. What should be the purchasing price for "Power supply" if the price of other materials cannot be changed? (report the price in 2 decimal points). To achieve a target direct labour budget of $340,000 in 2022, what should be the labour rate for Beta 5 if the direct labour rare for Alpha 5 and Alpha 7 cannot be changed? (report the rate in 2 decimal points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions