Portfolio Project · Business Systems

MEDIA BOOKING SYSTEM

Media booking environment supporting revenue analysis, cost of goods sold reporting, gross profit visibility, and management reporting by Week, Month, Quarter, and Year — with multi-user operational access and real-time reporting outputs.

Selected screens illustrating booking operations, revenue analytics, and management reporting:

MBS sale contracts list — List of sale contracts, the left window lists contracts, the middle window shows the discount of the channel, the right window is a discount of some special time codes which are differnt with the channel's discount (if any).

MBS time codes and unit prices — List of time codes and unit prices of each duration. Select the TV station, select the channel, select time code in the left window, see the corresponding in the right window.

MBS booking form details — Details of booking form, customer selection, product selection, sale contract. Continuously, select the channel, select the time code, select the purchasing contract, select the days of the month corresponding to each time code for each row.

MBS net advertising revenue summary — Summary of net advertising revenue (after deducting discounts).

MBS revenue and COGS by time code — Summary of revenue and cost of goods sold by time Code.

Summary of revenue and cost of goods sold by Brand.

MBS COGS by supplier — Summary of cost of goods sold by Supplier.

MBS revenue by customer — Summary of revenue by Customer.

MBS gross profit margin analysis — Analysis of gross profit margin according to optional objects: Customers, Suppliers, Channels, Time Codes, Brands.

MBS revenue period analysis — Analyze revenue on periods and draw the graph by options: Week, Month, Quarter, Year.

MBS revenue and COGS analysis by subject and period — Analysis of revenue and cost of goods sold by subjects and periods by options: Week, Month, Quarter, Year and Customer, Supplier, TV station, Channel. There are 16 results corresponding to 16 options needed to report.