Urgenthomework logo
UrgentHomeWork
Live chat

Loading..

Itech1100 Working Time Of The Assessment Answers

Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Book Zone.Your spreadsheet should be configured such that the working hours, hourly rates, and fixed and utility costs can be varied easily.Document your findings in your ePortfolio page (approximately 100 words).
Obtaining Books
Throughout the day, customers come to Book Zone to buy books, and occasionally to sell them.When people bring in books to sell to Book Zone, the staff member on duty will review the books and make an offer for each one individually.Currently, the process for determining how much the book shop will pay for a book is entirely subjective.
Staff members offer an amount per book based on the quality of the book, and how popular they think it is, and how they are feeling at the time.The sale amount is always simply double the amount paid and is set at the same time - if Book Zone pays $3.00 for a book, they will put it on sale with a marked price of $6.00.

(Book Zone does not deal in rare or antique books)
For several months, staff have been keeping track of the date and time, quality, publication year and amount paid for each book in a spreadsheet. This spreadsheet is available for download on Moodle.
 
Task 2 - Sales team offers
Using Excel, process the history of purchases spreadsheet and use appropriate charts to visualize:How the prices paid differed for each staff member; and How the prices paid have changed over time Describe your findings in your ePortfolio (approximately 250 words), and attach the Excel file to your page.
Process automation
Alexa and Bertha want to improve the consistency of how they pay for and price books.They'd like to standardize on three standard price offers, and have designed the following process to determine how to allocate them, including the option of rejecting the book altogether.The staff have already agreed on how to determine whether a book is terrible, poor, or good. Book purchase Customer 

Task 3 - Automation
Using Excel, create a spreadsheet page that automates the above process, allowing a member of the team to enter whether the book is hardcover, its publication year, and its condition, and receive a price to offer.Ensure that you include enough text and formatting to make your spreadsheet usable by a member of the Book Zone team, or by a University lecturer.
Your spreadsheet should be configured such that the Low, Medium and High prices can be varied easily.Describe how you automated the process (approx 150 words), and attach your Excel file to your ePortfolio.
 
Task 4 - Price setting
Using Excel and the historical data you have available, determine sets of prices which meet the objectives of the following scenarios: Scenario one: Total offer prices are approximately the same as for the historical data
Scenario two: Assuming all books purchased are sold, allow all staff to draw the same wage as Cassandra.

Answer:

The staff salary of Bertha, Alexa as well as Cassandra is mainly represented with the help of the excel sheet that is generally made for making effective calculation for the daily hours of working, hourly wages as well as about the entire working time of the organization. It is found that the overall expense that is mainly calculated with the help of the calculated values is mainly achieved with the help of addition. It is identified from the overall excel that Bertha, Alexa as well as Cassandra have proper average working hours and the entire working hours are 3.3, 3.3 and 5 and 514.8, 514.8 and 1300 respectively. It is found that the total cost that is estimated for the entire salaries are $28600 and $3300 for the various general workers making it total of $36,480.

Task 2

 It is found that the employees of the organizations are generally handling the customers in a proper way and the customers generally utilizes their own method of payment for the books that they received. It is found that Cassandra had priced the books as per the aggregation of the employees in comparison to Bertha and Alexa. The entire working hours of Cassandra is much more as compared to both Alexa and Bertha. The pricing that is used by Cassandra was much better for the books whereas the pricing that is made by Anne and Bertha for the books is quite less.

The average working hours of Bertha, Cassandra as well as Alexa will be around 3.3, 5 and 3.3 respectively. It is found that the entire working hours of Cassandra was about 1300 hours in comparison to 5.14.8 working hours of Alexa and Bertha. Hence, it has been found to be evident so that implications that are related with performance is mainly due to the working hours of each of them that would help in representing the final deliverable of the project. After comparison between Alexa and Bertha, it is found that Alexa has made worst pricing of the books.

Task 3

            The development of understanding is considered as one of the important factor that generally had resulted in understanding the entire process of automation. It is found that transactions of the store in the giving the limit of time period that generally have occurred that would form alignment by keeping appropriate track records for most of the project activities. The overall transaction that generally have taken place would generally be responsible for the implications of proper operation development as well as storage of time as well as data for the various interactions that have taken place.

Task 4

The price related idea is mainly included within the study that is helpful in meeting the expected deliverable that is associated with the project. The utilization of paper mainly lies in the entire calculation that is included due to the implications of the results estimated final result. The results that are attained due to the development of Ms excel file which would generally help in forming the entire analysis of the objective that is achieved. The prices which are generally offered with the help of the employees which had been set in a proper precise manner for attaining the desired outcome of the project.

Scenario 1:

 The study which had uncovered the entire prices which had generally been offered as per the implementation of the historical data alignment within the entire projects. The alignment of the facts which would generally be supplied for proper alignment of the prices which are generally offered for effective price gain.

Scenario 2:

 The study would generally helpful in reflecting that the books that are purchased would might assumed for being processed with the help of Alexa and Bertha. The alignment of the orders that is done by Alexa as well as Bertha would generally have supported by the salary of Cassandra as the prices which are revised for the constructed materials are generally aligned for the implication of the percentage of operating cost.

Bibliography

Blitz, A. (2016). Beset by the digital revolution successful retailers embrace technology that enhances customer value. Strategy & Leadership, 44(6), 16-24.                        

Gabor, D., & Brooks, S. (2017). The digital revolution in financial inclusion: international development in the fintech era. New Political Economy, 22(4), 423-436.

Luengo, M. (2014). Constructing the Crisis of Journalism: Towards a cultural understanding of the economic collapse of newspapers during the digital revolution. Journalism studies, 15(5), 576-585.

Vanishree, K., & Raghavendra, H. (2017). A Study on Implications of Digital Revolution in the Field of HR. Adarsh Journal of Management Research, 127-131.


Buy Itech1100 Working Time Of The Assessment Answers Online


Talk to our expert to get the help with Itech1100 Working Time Of The Assessment Answers to complete your assessment on time and boost your grades now

The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.


Get Online Support for Itech1100 Working Time Of The Assessment Answers Assignment Help Online


); }
Copyright © 2009-2023 UrgentHomework.com, All right reserved.